Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding multiple cascade paths
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01340693
Message ID:
01340827
Views:
8
Keep the FK but set ON DELETE NONE

>
>Thx. Thought that might be the answer ; got it working for cascading the deletes. But that leaves the other half of the equation : How to prevent insertions in the RowColumns table if the ColumnId doesn't exist in the Columns table ?
>
>Regards,
>Viv
>
>>You can replace one of ON DELETE CASCADE to RowColumns with a trigger.
>>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform