整理碎片

USE BookFactoryDECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR SELECT TABLE_NAME FROM information_schema.tables WHERE table_type = 'base table' and [TABLE_NAME] <> 'sysdiagrams'..

第八个猴子

49人浏览 · 2010-12-09 11:26:00

第八个猴子 · 2010-12-09 11:26:00 发布

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/archive/2010/12/09/1901015.html

AI编程社区

汇聚全球AI编程工具，助力开发者即刻编程。

更多推荐