Mega Code Archive

 

Categories / MySQL Tutorial / Data Dictionary

 

The INFORMATION_SCHEMA TRIGGERS Table

The TRIGGERS table provides information about triggers. mysql> desc INFORMATION_SCHEMA.TRIGGERS; +----------------------------+--------------+------+-----+---------+-------+ | Field                      | Type         | Null | Key | Default | Extra | +----------------------------+--------------+------+-----+---------+-------+ | TRIGGER_CATALOG            | varchar(512) | YES  |     | NULL    |       | | TRIGGER_SCHEMA             | varchar(64)  | NO   |     |         |       | | TRIGGER_NAME               | varchar(64)  | NO   |     |         |       | | EVENT_MANIPULATION         | varchar(6)   | NO   |     |         |       | | EVENT_OBJECT_CATALOG       | varchar(512) | YES  |     | NULL    |       | | EVENT_OBJECT_SCHEMA        | varchar(64)  | NO   |     |         |       | | EVENT_OBJECT_TABLE         | varchar(64)  | NO   |     |         |       | | ACTION_ORDER               | bigint(4)    | NO   |     | 0       |       | | ACTION_CONDITION           | longtext     | YES  |     | NULL    |       | | ACTION_STATEMENT           | longtext     | NO   |     |         |       | | ACTION_ORIENTATION         | varchar(9)   | NO   |     |         |       | | ACTION_TIMING              | varchar(6)   | NO   |     |         |       | | ACTION_REFERENCE_OLD_TABLE | varchar(64)  | YES  |     | NULL    |       | | ACTION_REFERENCE_NEW_TABLE | varchar(64)  | YES  |     | NULL    |       | | ACTION_REFERENCE_OLD_ROW   | varchar(3)   | NO   |     |         |       | | ACTION_REFERENCE_NEW_ROW   | varchar(3)   | NO   |     |         |       | | CREATED                    | datetime     | YES  |     | NULL    |       | | SQL_MODE                   | longtext     | NO   |     |         |       | | DEFINER                    | longtext     | NO   |     |         |       | +----------------------------+--------------+------+-----+---------+-------+ 19 rows in set (0.02 sec)