I'm struggling to drop a primary key.
I get the error:
An explicit DROP INDEX is not allowed on index 'MyTable.PrimaryKey'. It is being used for FOREIGN KEY constraint enforcement.
"sp_helpindex MyTable", returns 1 entry:
PrimaryKey, nonclustered, unique located on PRIMARY, ID
I also tried:
alter table MyTable DROP CONSTRAINT PrimaryKey
I even went as far as dropping all primary keys and foreign keys on the entire database, but the error still pops up. Any ideas?