W3cubDocs
/
SQLite
W3cubTools
Cheatsheets
About
create-trigger-stmt
CREATE
TEMP
TEMPORARY
TRIGGER
IF
NOT
EXISTS
schema-name
.
trigger-name
BEFORE
AFTER
INSTEAD
OF
DELETE
INSERT
UPDATE
OF
column-name
,
ON
table-name
FOR
EACH
ROW
WHEN
expr
BEGIN
update-stmt
;
END
insert-stmt
delete-stmt
select-stmt
Used by:
sql-stmt
References:
delete-stmt
expr
insert-stmt
select-stmt
update-stmt
See also:
lang_createtrigger.html
SQLite is in the Public Domain.
https://sqlite.org/syntax/create-trigger-stmt.html