Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FK for preventing parental deletions.
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00720778
Message ID:
00723509
Views:
16
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform