Type the trigger header — read off the event, condition, and action:
Type the trigger header — read off the event, condition, and action:
Answer
CREATE TRIGGER reg_drop_audit AFTER DELETE ON registrations FOR EACH ROW EXECUTE FUNCTION log_drop();
Event = AFTER DELETE ON registrations; condition = FOR EACH ROW; action = run log_drop(). No one calls it — the DELETE event activates it automatically.