create trigger syntax code example
Example 1: CREATE trigger SQL
CREATE OR REPLACE TRIGGER {trigger_name}
BEFORE | AFTER
INSERT | UPDATE | DELETE
ON {table_name}
(FOR EACH ROW)
{operation to be executed}
CREATE TRIGGER log_updates
AFTER INSERT OR UPDATE ON Person
FOR EACH ROW
INSERT INTO LogPerson(ts, IdPerson, surname)
VALUES(CURRENT_TIMESTAMP, NEW.id, NEW.surname);
Example 2: create trigger syntax
CREATE TRIGGER schema_name.trigger_name
ON table_name
AFTER INSERT,UPDATE,DELETE
AS
{sql_statements}