SQL AFTER DELETE Trigger Explained
SQL - AFTER DELETE TRIGGER
Definition
An AFTER DELETE Trigger is a trigger that automatically executes after a record has been successfully deleted from a table. It is commonly used for auditing, logging deleted records, and performing related actions after data removal.
Syntax
CREATE TRIGGER trigger_name
AFTER DELETE
ON table_name
FOR EACH ROW
BEGIN
-- Trigger statements
END;