MySQL 8.4 Release Notes
27.3.2 触发器元数据
To obtain metadata about triggers:
-
Query the
TRIGGERStable of theINFORMATION_SCHEMAdatabase. See Section 28.3.44, “The INFORMATION_SCHEMA TRIGGERS Table”. -
Use the
SHOW CREATE TRIGGERstatement. See Section 15.7.7.12, “SHOW CREATE TRIGGER Statement”. -
Use the
SHOW TRIGGERSstatement. See Section 15.7.7.39, “SHOW TRIGGERS Statement”.