Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FKEY and cacaded Deletes
Message
From
07/02/2002 15:23:09
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
FKEY and cacaded Deletes
Miscellaneous
Thread ID:
00616949
Message ID:
00616949
Views:
64
Hi,

SQL7 - Is there no way I can have both an FKey constraint and a cascaded delete trigger from parent to child table? I try and the FKey constraint hits before the trigger - thus I effectively can't delete a parent record. Is this fixed in SQL2000?

TIA,
Ken B. Matson
GCom2 Solutions
Next
Reply
Map
View

Click here to load this message in the networking platform