23.3.2 Trigger Metadata
To obtain metadata about triggers:
Query the
TRIGGERS
table of theINFORMATION_SCHEMA
database. See Section 24.29, “The INFORMATION_SCHEMA TRIGGERS Table”.Use the
SHOW CREATE TRIGGER
statement. See Section 13.7.5.11, “SHOW CREATE TRIGGER Statement”.Use the
SHOW TRIGGERS
statement. See Section 13.7.5.38, “SHOW TRIGGERS Statement”.