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.

• Next in forum: Re: How To Return A "Range Of Rows"??
• Prev in forum: Re: How To Return A "Range Of Rows"??
• Thread view: Disabling or Getting Rid of Foreign Keys So I Can Drop My Table

[Reply to this message]