Metadata about triggers can be obtained as follows:
Query the TRIGGERS table of the
INFORMATION_SCHEMA database. See
Section 20.23, “The INFORMATION_SCHEMA TRIGGERS Table”.
Use the SHOW TRIGGERS
statement. See Section 13.7.5.40, “SHOW TRIGGERS Syntax”.