Note
This view is available starting with V3.2.3.
Overview
The information_schema.TRIGGERS view displays information about triggers.
Columns
Column |
Type |
Nullable |
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 instances with the sameEVENT_MANIPULATIONandACTION_TIMINGThe order and position of trigger operations in the trigger list for a value 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. The value can be BEFORE or 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 identifier of the old column. This value 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 Trigger 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_connectionThe value 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;