Solving the SQL Server Multiple Cascade Path Issue with a Trigger
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Fri, 24 Aug 2012 06:00:00 UT
Indexed on
2012/08/29
21:46 UTC
Read the original article
Hit count: 210
Filed under:
This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.
Keep your database and application development in sync SQL Connect is a Visual Studio add-in that brings your databases into your solution. It then makes it easy to keep your database in sync, and commit to your existing source control system. Find out more. |
© SQL Server Central or respective owner