Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Drop Table
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01360514
Message ID:
01360562
Views:
7
>>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

Thanks for the reply and link.
I do not have any problems dropping the table w/o dropping the FK contraint first.
The table that I am dropping does not have any FK contraints linking to the table but rather the table that I am dropping is linking to another table (that is not beeing dropped).

Thanks,
Einar
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform