Unable to drop constraint in sql server 2005 "Could not drop constraint. See previous errors"
Posted
by DannykPowell
on Stack Overflow
See other posts from Stack Overflow
or by DannykPowell
Published on 2010-04-07T13:53:32Z
Indexed on
2010/04/07
16:23 UTC
Read the original article
Hit count: 197
I'm trying to drop a constraint on a db table, something like:
ALTER TABLE MyTable drop CONSTRAINT FK_MyTable_AnotherTable
But the execution just runs and runs. If I stop it I see:
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors.
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
© Stack Overflow or respective owner
