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: 9596 | Post Order: 114