- In SQL Server 2014 or 2016, you have several tables, each of which has a PRIMARY KEY constraint specified.
- You create a cascading chain for those tables by using the FOREIGN KEY constraint together with the ON DELETE CASCADE action.
- You create an AFTER DELETE trigger for each table.
- You delete a row from the parent table. This triggers the AFTER DELETE triggers and the ON DELETE CASCADE action chain.
Article ID: 4009823 - Last Review: 20.3.2017 - Revision: 12