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!