MySQL 5.6 Release Notes
To obtain metadata about triggers:
Query the
TRIGGERS
table of theINFORMATION_SCHEMA
database. See Section 21.3.27, “The INFORMATION_SCHEMA TRIGGERS Table”.Use the
SHOW CREATE TRIGGER
statement. See Section 13.7.5.13, “SHOW CREATE TRIGGER Statement”.Use the
SHOW TRIGGERS
statement. See Section 13.7.5.39, “SHOW TRIGGERS Statement”.