The TRIGGERS view contains information about triggers. To view trigger information for a table, you must have the TRIGGER privilege on that table.
| Column | Description |
|---|---|
TRIGGER_CATALOG |
The catalog to which the trigger belongs. This value is always def. |
TRIGGER_SCHEMA |
The schema (database) to which the trigger belongs. |
TRIGGER_NAME |
The name of the trigger. |
EVENT_MANIPULATION |
The type of operation on the associated table that activates the trigger. Possible values: INSERT (row inserted), DELETE (row deleted), or UPDATE (row modified). |
EVENT_OBJECT_CATALOG |
The catalog where the associated table exists. This value is always def. |
EVENT_OBJECT_SCHEMA |
The schema (database) in which the associated table exists. |
EVENT_OBJECT_TABLE |
The name of the associated table. |
ACTION_ORDER |
The ordinal position of the trigger action in the list of triggers on the same table, with the same EVENT_MANIPULATION and ACTION_TIMING. |
ACTION_CONDITION |
Always NULL. |
ACTION_STATEMENT |
The statement executed when the trigger is activated. This text is encoded in UTF-8. |
ACTION_ORIENTATION |
Always ROW. |
ACTION_TIMING |
Indicates whether the trigger activates before or after the triggering event. Possible values: BEFORE or AFTER. |
ACTION_REFERENCE_OLD_TABLE |
Always NULL. |
ACTION_REFERENCE_NEW_TABLE |
Always NULL. |
ACTION_REFERENCE_OLD_ROW |
The old column identifier. Always OLD. |
ACTION_REFERENCE_NEW_ROW |
The new column identifier. Always NEW. |
CREATED |
The date and time when the trigger was created. This is a TIMESTAMP(2) value, which includes fractional seconds. |
SQL_MODE |
The SQL mode in effect when the trigger was created and under which the trigger executes. |
DEFINER |
The account named in the DEFINER clause, usually the user who created the trigger, in 'user_name'@'host_name' format. |
CHARACTER_SET_CLIENT |
The session value of character_set_client when the trigger was created. |
COLLATION_CONNECTION |
The session value of collation_connection when the trigger was created. |
DATABASE_COLLATION |
The collation of the database associated with the trigger. |
For more information, see the MySQL documentation: The INFORMATION_SCHEMA TRIGGERS Table.