sql索引

DECLARE @TableName sysname, @msg varchar(100), @cmd varchar(100)
DECLARE table_cur CURSOR FOR
SELECT name FROM sysobjects WHERE type='u' and not name like 'tmp%'
OPEN table_cur
FETCH NEXT FROM table_cur INTO @TableName
WHILE @@fetch_status = 0
BEGIN
IF @@fetch_status = -2
CONTINUE
SELECT @msg = 'Building indexes for table ' + @TableName + ' …'
PRINT @msg
SELECT @cmd = 'DBCC DBREINDEX ("' + @TableName + '")'
EXEC (@cmd)
PRINT ' '
FETCH NEXT FROM table_cur INTO @TableName
END
DEALLOCATE table_cur
GO