一次性重建资料库所有资料表的 index

Calvin

USE Purchase --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR  

SELECT TABLE_SCHEMA + '.[' +  table_name + ']' FROM INFORMATION_SCHEMA.TABLES

WHERE table_type = 'BASE TABLE'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0

BEGIN

print 'Rebuild:' + @TableName

DBCC DBREINDEX(@TableName,' ',90)

FETCH NEXT FROM TableCursor INTO @TableName

END

CLOSE TableCursor  

DEALLOCATE TableCursor