Contents

  1. See also

The Information Schema TRIGGERS table contains information about triggers.

It has the following columns:

ColumnDescription
TRIGGER_CATALOGAlways def.
TRIGGER_SCHEMADatabase name in which the trigger occurs.
TRIGGER_NAMEName of the trigger.
EVENT_MANIPULATIONThe event that activates the trigger. One of INSERT, UPDATE or 'DELETE.
EVENT_OBJECT_CATALOGAlways def.
EVENT_OBJECT_SCHEMADatabase name on which the trigger acts.
EVENT_OBJECT_TABLETable name on which the trigger acts.
ACTION_ORDERIndicates 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). Before MariaDB 10.2.3 introduced the FOLLOWS and PRECEDES clauses, always 0
ACTION_CONDITIONNULL
ACTION_STATEMENTTrigger body, UTF-8 encoded.
ACTION_ORIENTATIONAlways ROW.
ACTION_TIMINGWhether the trigger acts BEFORE or AFTER the event that triggers it.
ACTION_REFERENCE_OLD_TABLEAlways NULL.
ACTION_REFERENCE_NEW_TABLEAlways NULL.
ACTION_REFERENCE_OLD_ROWAlways OLD.
ACTION_REFERENCE_NEW_ROWAlways NEW.
CREATEDAlways NULL.
SQL_MODEThe SQL_MODE when the trigger was created, and which it uses for execution.
DEFINERThe account that created the trigger, in the form user_name@host_name
CHARACTER_SET_CLIENTThe client character set when the trigger was created, from the session value of the character_set_client system variable.
COLLATION_CONNECTIONThe client collation when the trigger was created, from the session value of the collation_connection system variable.
DATABASE_COLLATIONCollation of the associated database.

Queries to the TRIGGERS table will return information only for databases and tables for which you have the TRIGGER privilege. Similar information is returned by the SHOW TRIGGERS statement.

See also

Comments

Comments loading...