>SELECT name FROM sysindexes >WHERE id = OBJECT_ID(N'MyTable') 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 = 'MyTable') >Thanks, this works.
