~/ learn/ comp-378/ cards/ Triggers, Stored Procedures & SQL/PSM
1 of 4

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.

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/3cdcfe21-898c-4856-bc05-c64f747fe4f2/flashcard utf-8 LF