CREATE TRIGGER
Valentina DB has a few kinds of triggers:
- CREATE TRIGGER DML - on Data Modification Language of SQL.
- CREATE TRIGGER DDL - Data Definition Language of SQL.
Syntax
The common syntax of all triggers looks as below. Please check the page about the specific kind of trigger to see details.
trigger_definition : CREATE [OR REPLACE] TRIGGER [IF NOT EXISTS] trigger_name trigger_action_time { trigger_dml_event_clause | trigger_db_event_clause | trigger_ddl_event_clause } compound_statement