Home Forums SQL Server 2005 Administering when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'.It is being used for FOREIGN KEY constraint enforcement. " RE: when I try to drop the index I am getting error "An explicit DROP INDEX is not allowed on index 'dbo.crdtr.crdtr_ak1'.It is being used for FOREIGN KEY constraint enforcement. "

  • August 20, 2009 at 1:36 pm

    #1042391

    You can use the sp_helpconstraint proc to help you out. The bottom section of the output will be the foreign keys that reference the table.