20.3.2 Trigger Metadata

Metadata about triggers can be obtained as follows:

• Query the TRIGGERS table of the INFORMATION_SCHEMA database. See Section 21.27, “The INFORMATION_SCHEMA TRIGGERS Table”.

• Use the SHOW CREATE TRIGGER statement. See Section 13.7.5.13, “SHOW CREATE TRIGGER Syntax”.

• Use the SHOW TRIGGERS statement. See Section 13.7.5.39, “SHOW TRIGGERS Syntax”.