Cannot drop an index that is being used for PK constraint enforcement (MS SQL Server 2008)
I am trying to execute the following SQL command:
DROP INDEX pk_name_PK ON [dbo].[TableName];
I am getting the following error:
It is being used for PRIMARY KEY constraint enforcement.
Please help! Thanks!