Part 47 Instead of delete triggers in sql server
An INSTEAD OF DELETE trigger in SQL Server is a special type of DML (Data Manipulation Language) trigger that executes instead of the actual DELETE statement on a specified table or view.
Instead of allowing the default deletion process to occur, this trigger intercepts the DELETE command and executes the custom logic defined within the trigger body.