USE DatabaseName --數(shù)據(jù)庫名稱
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
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END
CLOSE TableCursor
DEALLOCATE TableCursor
以上語句直接運(yùn)行即可