DECLARE tableIndexes CURSOR LOCAL FOR SELECT name FROM sysindexes WHERE id = OBJECT_ID(N'ArchiveRetrieval') AND indid > 0 AND indid < 255 AND INDEXPROPERTY(id, name, 'IsStatistics') = 0 AND name <> (SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_TYPE = 'PRIMARY KEY' AND TABLE_NAME = '[ArchiveRetrieval]') ORDER BY indid DESCIf I remove the second part, all the indexes are found. But, I need it as I do not want to select an index which is used as a primary key.