I'm getting the following message when I try to drop a clustered index:
An explicit DROP INDEX is not allowed on index 'WS10702.PKWS10702'. It is being used for PRIMARY KEY constraint enforcement.
This table is a 'work' table and really doesn't need a clustered index. It has several non-clustered indexes that I would like to keep.
My problem is I can't find out where the constraint is used. I tried sp_fkeys, but I'm getting no results. I've tried looking in the sysobjects table, but found only 1 'F' object in the whole database for a totally unrelated table. There are at least 200 tables in this database, so I'd prefer not to look at each table's design properties in EM. Can anyone tell me where else to look or how to get sp_fkeys to work?
Thanks
An explicit DROP INDEX is not allowed on index 'WS10702.PKWS10702'. It is being used for PRIMARY KEY constraint enforcement.
This table is a 'work' table and really doesn't need a clustered index. It has several non-clustered indexes that I would like to keep.
My problem is I can't find out where the constraint is used. I tried sp_fkeys, but I'm getting no results. I've tried looking in the sysobjects table, but found only 1 'F' object in the whole database for a totally unrelated table. There are at least 200 tables in this database, so I'd prefer not to look at each table's design properties in EM. Can anyone tell me where else to look or how to get sp_fkeys to work?
Thanks