Skip to content
Advertisement

Unable to drop constraint in SQL server 2005, “Could not drop constraint. See previous errors”

I’m trying to drop a constraint on a DB table, something like:

But the execution just runs and runs. If I stop it I see:

Web search throws up various pages but note that the constraint is properly named and I am trying to remove it using the correct name

Advertisement

Answer

Found a way to sort this, although I don’t understand why it was necessary.

Have been able to drop the constraint by disabling it first:

The drop then completes fine

Would still welcome any comments on the reason why this is necessary

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement