DECLARE tableIndexes CURSOR FOR SELECT name FROM sysindexes WHERE id = OBJECT_ID(N'MyTable') AND indid > 0 AND indid < 255 AND INDEXPROPERTY(id, name, 'IsStatistics') = 0 ORDER BY indid DESC OPEN tableIndexes FETCH NEXT FROM tableIndexes INTO @indexName WHILE @@fetch_status = 0 BEGIN SET @dropIndexSql = N'DROP INDEX MyTable.' + @indexName EXEC sp_executesql @dropIndexSql FETCH NEXT FROM tableIndexes INTO @indexName END