Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FK for preventing parental deletions.
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00720778
Message ID:
00723509
Vues:
17
>Are you sure? You mean if I have a foreign key relationship defined, I have to delete the child records before you delete the parent record. Mabey Im just reading this wrong...

Yes. The FK constraint will throw an exception if you try to remove the parent and children exist, if cascading deletes are not enabled. Also, an exception will be thrown if you try to use a parent ID in the child row that doesn't exist.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform