Feodor Georgiev's blog

Here is how to generate a script which drops all indexes in your database for SQL 2005 – 2008:

?View Code TSQLDECLARE @indexName VARCHAR(128)
DECLARE @tableName VARCHAR(128)
DECLARE [indexes] CURSOR FOR
SELECT I.[name] AS [Index],
S.[name] AS [Table]
FROM [sysindexes] I
INNER JOIN [sysobjects] S
ON I.[id] = S.[id]
WHERE I.[name] IS NOT NULL
AND S.[type] = ‘U’
AND I.INDID > 0
AND I.INDID < 255
AND (I.STATUS & 64)=0
–uncomment below to eliminate PK or UNIQUE indexes;
–what i . . . → Read More: Drop and create all indexes in a database