To obtain metadata about triggers:
Query the TRIGGERS table of the INFORMATION_SCHEMA database. See Section 26.3.45, “The INFORMATION_SCHEMA TRIGGERS Table”.
Use the SHOW CREATE TRIGGER statement. See Section 13.7.7.11, “SHOW CREATE TRIGGER Statement”.
Use the SHOW TRIGGERS statement. See Section 13.7.7.40, “SHOW TRIGGERS Statement”.