- 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.
ID članka: 4009823 – Zadnji pregled: 17. apr. 2017 – Revizija: 14