MySQL :: MySQL 5.5 Reference Manual :: 20.3.2 Trigger Metadata

version 5.5

8.0 current
5.7
5.6

5.6 Japanese

MySQL 5.5 Reference Manual / ... / Trigger Metadata

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.26, “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”.

PREV HOME UP NEXT

User Comments

User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.