游标模版+批量删除表索引

DECLARE @index TABLE(index_name nVARCHAR(max),index_des nVARCHAR(max),index_keys nVARCHAR(max)) INSERT INTO @index ( index_name, index_des, index_keys ) EXEC sp_helpindex 'ycmis.dbo.费用表' --游标模版 DECLARE @indexname NVARCHAR(200) DECLARE pcurr CURSOR FOR SELECT index_name FROM @index OPEN pcurr FETCH NEXT FROM pcurr INTO @indexname WHILE (@@FETCH_STATUS = 0) BEGIN -- PRINT @indexname DECLARE @dropindex_sql VARCHAR(800) SET @dropindex_sql ='drop index dbo.费用表.'+@indexname EXEC (@dropindex_sql) ---------------------------- FETCH NEXT FROM pcurr INTO @indexname END CLOSE pcurr DEALLOCATE pcurr