Learn SQL Database Programming

Syntax for triggers

To create a trigger, you can use the following sample syntax. The square brackets indicate you could use any one of those options in place of those listed options:

CREATE TRIGGER triggername [BEFORE | AFTER] [INSERT | UPDATE| DELETE] ON tablename FOR EACH ROW triggerbody;

To create multiple triggers, you can use the following sample syntax. The square brackets indicate you could use any one of those options in place of those listed options:

CREATE TRIGGER triggername [BEFORE | AFTER] [INSERT | UPDATE| DELETE] ON tablename FOR EACH ROW [FOLLOWS | PRECEDES] anothertriggernametriggerbody;

To delete a trigger, you can use the following sample syntax:

DROP TRIGGER triggername;