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 |