|
Posted by apax999@gmail.com on 04/18/07 19:09
Kinda new to SQL, using SQL Server 2005.
I have some foreign keys in a couple of tables. I need to drop these
tables, but can't since I'll get the error:
Msg 3726,
Level 16, State 1, Line 1
Could not drop object 'Client' because it is referenced by a FOREIGN
KEY constraint.
I'm not sure how to disable or get rid of these foreign keys so that I
can drop my tables. I tried:
ALTER TABLE Client NOCHECK CONSTRAINT ALL
Alter Table Client Drop Column Foreign Key Boss_ID;
I went into the Object Explorer and deleted the FK lines from each
table, but still the same error.
What am I doing wrong?
Thanks for your help.
[Back to original message]
|