Login | Register
Metadata about triggers can be obtained as follows:
Query the TRIGGERS table of the INFORMATION_SCHEMA database. See Section 20.27, “The INFORMATION_SCHEMA TRIGGERS Table”.
TRIGGERS
INFORMATION_SCHEMA
INFORMATION_SCHEMA TRIGGERS
Use the SHOW CREATE TRIGGER statement. See Section 13.7.5.13, “SHOW CREATE TRIGGER Syntax”.
SHOW CREATE TRIGGER
Use the SHOW TRIGGERS statement. See Section 13.7.5.39, “SHOW TRIGGERS Syntax”.
SHOW TRIGGERS
© 2014, Oracle Corporation and/or its affiliates
User Comments