27.3.2 Trigger Metadata

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

27.3.2 Trigger Metadata

To obtain metadata about triggers:

• Query the TRIGGERS table of the INFORMATION_SCHEMA database. See Section 28.3.44, “The INFORMATION_SCHEMA TRIGGERS Table”.
• Use the SHOW CREATE TRIGGER statement. See Section 15.7.7.12, “SHOW CREATE TRIGGER Statement”.
• Use the SHOW TRIGGERS statement. See Section 15.7.7.40, “SHOW TRIGGERS Statement”.