Create or modify a trigger
CREATE OR MODIFY TRIGGER trigger_name
WHEN EVENT
ON table_name TRIGGER_TYPE
EXECUTE stored_procedure;
Create a trigger invoked before a new row is inserted into the person table
WHEN BEFORE – invoke before the event occurs AFTER – invoke after the event occurs EVENT INSERT – invoke for INSERT UPDATE – invoke for UPDATE DELETE – invoke for DELETE TRIGGER_TYPE FOR EACH ROW FOR EACH STATEMENT CREATE TRIGGER before_insert_person BEFORE INSERT ON person FOR EACH ROW EXECUTE stored_procedure;
Delete a specific trigger
DROP TRIGGER trigger_name