MySQL 9.2 Release Notes
To obtain metadata about triggers:
Query the
TRIGGERS
table of theINFORMATION_SCHEMA
database. See Section 28.3.46, “The INFORMATION_SCHEMA TRIGGERS Table”.Use the
SHOW CREATE TRIGGER
statement. See Section 15.7.7.13, “SHOW CREATE TRIGGER Statement”.Use the
SHOW TRIGGERS
statement. See Section 15.7.7.40, “SHOW TRIGGERS Statement”.