The Information Schema TRIGGERS table contains detailed information about triggers, including the event, timing, and action statement.
The Information Schema TRIGGERS table contains information about triggers.
It has the following columns:
TRIGGER_CATALOG
Always def.
TRIGGER_SCHEMA
Database name in which the trigger occurs.
TRIGGER_NAME
Queries to the TRIGGERS table will return information only for databases and tables for which you have the TRIGGER . Similar information is returned by the statement.
This page is licensed: CC BY-SA / Gnu FDL
Name of the trigger.
EVENT_MANIPULATION
The event that activates the trigger. Prior to MariaDB 12.0, one of INSERT, UPDATE or DELETE. From MariaDB 12.0, can contain multiple values, comma-separated.
EVENT_OBJECT_CATALOG
Always def.
EVENT_OBJECT_SCHEMA
Database name on which the trigger acts.
EVENT_OBJECT_TABLE
Table name on which the trigger acts.
ACTION_ORDER
Indicates the order that the action will be performed in (of the list of a table's triggers with identical EVENT_MANIPULATION and ACTION_TIMING values). See the FOLLOWS/PRECEDES clauses.
ACTION_CONDITION
NULL
ACTION_STATEMENT
Trigger body, UTF-8 encoded.
ACTION_ORIENTATION
Always ROW.
ACTION_TIMING
Whether the trigger acts BEFORE or AFTER the event that triggers it.
ACTION_REFERENCE_OLD_TABLE
Always NULL.
ACTION_REFERENCE_NEW_TABLE
Always NULL.
ACTION_REFERENCE_OLD_ROW
Always OLD.
ACTION_REFERENCE_NEW_ROW
Always NEW.
CREATED
Always NULL.
SQL_MODE
The SQL_MODE when the trigger was created, and which it uses for execution.
DEFINER
The account that created the trigger, in the form user_name@host_name
CHARACTER_SET_CLIENT
The client character set when the trigger was created, from the session value of the character_set_client system variable.
COLLATION_CONNECTION
The client collation when the trigger was created, from the session value of the collation_connection system variable.
DATABASE_COLLATION
Collation of the associated database.