数据库整理碎片

USE  BookFactory
DECLARE @TableName varchar(255) 
DECLARE TableCursor CURSOR FOR 
SELECT TABLE_NAME FROM information_schema.tables 
WHERE table_type = 'base table'  and [TABLE_NAME] <> 'sysdiagrams'
OPEN TableCursor 
FETCH NEXT FROM TableCursor INTO @TableName 
WHILE @@FETCH_STATUS = 0 
BEGIN 
DBCC DBREINDEX(@TableName,' ',90) 
print @TableName
FETCH NEXT FROM TableCursor INTO @TableName 
END 
CLOSE TableCursor 
DEALLOCATE TableCursor
原文地址:https://www.cnblogs.com/staid/p/1901102.html