Note
This view is available starting with V3.2.3.
Overview
The information_schema.TRIGGERS view displays information about triggers.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TRIGGER_CATALOG | varchar(512) | NO | The name of the directory to which the trigger belongs. This value is always 'def'. |
| TRIGGER_SCHEMA | varchar(64) | NO | The name of the schema (database) to which the trigger belongs. |
| TRIGGER_NAME | varchar(64) | NO | The name of the trigger. |
| EVENT_MANIPULATION | varchar(6) | NO | Trigger event. This is the type of operation that activates the trigger on the associated table. The value can be INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). |
| EVENT_OBJECT_CATALOG | varchar(512) | NO | The directory where the table associated with this trigger is located. This value is always 'def'. |
| EVENT_OBJECT_SCHEMA | varchar(64) | NO | The schema (database) where the table associated with this trigger is located. |
| EVENT_OBJECT_TABLE | varchar(64) | NO | The name of the table associated with this trigger. |
| ACTION_ORDER | bigint(20) | NO | In cases where multiple instances have the sameEVENT_MANIPULATIONandACTION_TIMINGThe order and position of trigger operations in the list of triggers on the same table. |
| ACTION_CONDITION | longtext | NO | This value is always NULL. |
| ACTION_STATEMENT | longtext | NO | The statements executed when the trigger is activated |
| ACTION_ORIENTATION | varchar(9) | NO | This value is always ROW. |
| ACTION_TIMING | varchar(6) | NO | Whether the trigger is activated before or after the triggering event. Valid values: BEFORE and AFTER. |
| ACTION_REFERENCE_OLD_TABLE | varchar(64) | NO | This value is always NULL. |
| ACTION_REFERENCE_NEW_TABLE | varchar(64) | NO | This value is always NULL. |
| ACTION_REFERENCE_OLD_ROW | varchar(3) | NO | The old column identifier, which is always 'OLD'. |
| ACTION_REFERENCE_NEW_ROW | varchar(3) | NO | New column identifier, whose value is always NEW. |
| CREATED | datetime(2) | YES | Date and time when the trigger was created. |
| SQL_MODE | text | NO | SQL mode in effect when the trigger is created |
| DEFINER | varchar(93) | YES | DEFINERThe account specified in the clause (usually the user who creates the trigger) is in the format of'user_name'@'host_name' |
| CHARACTER_SET_CLIENT | varchar(32) | NO | When creating a triggercharacter_set_clientThe value of the system variable in the current session. |
| COLLATION_CONNECTION | varchar(32) | NO | When creating a triggercollation_connectionValue of the system variable in the current session |
| DATABASE_COLLATION | varchar(32) | NO | The collation of the database associated with the trigger. |
| ---------------------------- | -------------- | ------ | ------ |
Sample query
Query the details of table t1.
SELECT * FROM information_schema.TRIGGERS;