23.3.2 Trigger Metadata
Metadata about triggers can be obtained as follows:
Query the TRIGGERS table of the INFORMATION_SCHEMA database. See Section 24.28, "The INFORMATION_SCHEMA TRIGGERS Table"
Use the SHOW CREATE TRIGGER statement. See Section 13.7.5.11, "SHOW CREATE TRIGGER Syntax".
Use the SHOW TRIGGERS statement. See Section 13.7.5.38, "SHOW TRIGGERS Syntax".