~/ 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/f60c9a7a-44f6-425b-954d-bd2a4d92737f/flashcard utf-8 LF