Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Drop Table
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01360514
Message ID:
01360562
Vues:
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

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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform