The INFORMATION_SCHEMA.TRIGGERS Table : INFORMATION_SCHEMA « Data Dictionary « MySQL Tutorial






The TRIGGERS table provides information about triggers.

mysql> desc INFORMATION_SCHEMA.TRIGGERS;
+----------------------------+--------------+------+-----+---------+-------+
| Field                      | Type         | Null | Key | Default | Extra |
+----------------------------+--------------+------+-----+---------+-------+
| TRIGGER_CATALOG            | varchar(512) | YES  |     | NULL    |       |
| TRIGGER_SCHEMA             | varchar(64)  | NO   |     |         |       |
| TRIGGER_NAME               | varchar(64)  | NO   |     |         |       |
| EVENT_MANIPULATION         | varchar(6)   | NO   |     |         |       |
| EVENT_OBJECT_CATALOG       | varchar(512) | YES  |     | NULL    |       |
| EVENT_OBJECT_SCHEMA        | varchar(64)  | NO   |     |         |       |
| EVENT_OBJECT_TABLE         | varchar(64)  | NO   |     |         |       |
| ACTION_ORDER               | bigint(4)    | NO   |     | 0       |       |
| ACTION_CONDITION           | longtext     | YES  |     | NULL    |       |
| ACTION_STATEMENT           | longtext     | NO   |     |         |       |
| ACTION_ORIENTATION         | varchar(9)   | NO   |     |         |       |
| ACTION_TIMING              | varchar(6)   | NO   |     |         |       |
| ACTION_REFERENCE_OLD_TABLE | varchar(64)  | YES  |     | NULL    |       |
| ACTION_REFERENCE_NEW_TABLE | varchar(64)  | YES  |     | NULL    |       |
| ACTION_REFERENCE_OLD_ROW   | varchar(3)   | NO   |     |         |       |
| ACTION_REFERENCE_NEW_ROW   | varchar(3)   | NO   |     |         |       |
| CREATED                    | datetime     | YES  |     | NULL    |       |
| SQL_MODE                   | longtext     | NO   |     |         |       |
| DEFINER                    | longtext     | NO   |     |         |       |
+----------------------------+--------------+------+-----+---------+-------+
19 rows in set (0.02 sec)








25.8.INFORMATION_SCHEMA
25.8.1.The INFORMATION_SCHEMA Database
25.8.2.The INFORMATION_SCHEMA.SCHEMATA Table
25.8.3.The INFORMATION_SCHEMA.TABLES Table
25.8.4.The INFORMATION_SCHEMA.COLUMNS Table
25.8.5.The INFORMATION_SCHEMA.STATISTICS Table
25.8.6.The INFORMATION_SCHEMA.USER_PRIVILEGES Table
25.8.7.The INFORMATION_SCHEMA.SCHEMA_PRIVILEGES Table
25.8.8.The INFORMATION_SCHEMA.TABLE_PRIVILEGES Table
25.8.9.The INFORMATION_SCHEMA.COLUMN_PRIVILEGES Table
25.8.10.The INFORMATION_SCHEMA.CHARACTER_SETS Table
25.8.11.The INFORMATION_SCHEMA.COLLATIONS Table
25.8.12.The INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY Table
25.8.13.The INFORMATION_SCHEMA.TABLE_CONSTRAINTS Table
25.8.14.The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
25.8.15.The INFORMATION_SCHEMA ROUTINES Table
25.8.16.The INFORMATION_SCHEMA.VIEWS Table
25.8.17.The INFORMATION_SCHEMA.TRIGGERS Table
25.8.18.The INFORMATION_SCHEMA.PROFILING Table