23.3.2 Trigger Metadata
To obtain metadata about triggers:
Query the
TRIGGERStable of theINFORMATION_SCHEMAdatabase. See Section 24.3.29, “The INFORMATION_SCHEMA TRIGGERS Table”.Use the
SHOW CREATE TRIGGERstatement. See Section 13.7.5.11, “SHOW CREATE TRIGGER Statement”.Use the
SHOW TRIGGERSstatement. See Section 13.7.5.38, “SHOW TRIGGERS Statement”.
© 2025 Oracle
Licensed under the GPLv2 License.