现在sql server2005的一个库中有几百张含有索引的表，进行索引的删除，而后新建

现在sql server2005的一个库中有几百张含有索引的表，进行索引的删除，而后新建

LZ 好意思就给10分么！你看都没人回答，少说也要 500分！(*^__^*)
-----------------------------------------------------------------------
----------------------------------------------------------------

----------------------------------------------------------------
use HMS;
declare @ClmH varchar(Max);
select @ClmH = coalesce(@ClmH+CH,CH)
from
(
select 'ALTER INDEX '+B.name+' ON '+A.name+' REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = OFF )'+';' as CH
from sys.objects A
inner join sys.indexes B on (A.object_id=B.object_id)
where A.type='U' and B.name is not null
) A
exec(@Clmh);
--------------
我空间里也有这个段。
使用的是 alert index rebuild 的方式。