Sql2000語(yǔ)法：

select 'DBCC DBREINDEX(' + object_name(id) + ','''')'

from sysindexes

where id in (select id from sysobjects where xtype='U') and indid in (0,1)

sql2005及以上版本語(yǔ)法：

select 'DBCC DBREINDEX(' + name + ','''')' from sys.tables where type_desc='USER_TABLE' order by name