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.

SQL Connect 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