Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Drop Table
Message
From
07/11/2008 11:20:31
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Drop Table
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01360514
Message ID:
01360531
Views:
8
>When I drop a table using DROP TABLE all the foreign key constraints are dropped implicitly because foreign key contraints are part of the table object, correct?
>
>Thanks,
>Einar

No, you should drop them first, AFAIK.

See http://weblogs.asp.net/jgalloway/archive/2006/04/12/442616.aspx
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform