SQL Server > Triggers

AFTER DELETE trigger in SQL Server

How to create AFTER DELETE triggers in SQL Server?

Same as UPDATE, we do delete also. The only difference is in case of INSERT or UPDATE, the logical table name gets created with INSERTED or DELETED record is “inserted” and in case of DELETE trigger the logical table name gets created is “deleted” with the record data that gets deleted.

Read more about creating AFTER INSERT or AFTER UPDATE triggers here.

This trigger fires when a record gets deleted from the table on which it is created.

Views: 9663 | Post Order: 114