MySQL 5.5 Release Notes
Metadata about triggers can be obtained as follows:
Query the
TRIGGERS
table of theINFORMATION_SCHEMA
database. See Section 21.26, “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”.