content_image/749158.jpg content_image/749159.jpg content_image/749167.jpg content_image/749160.jpg
## 25.3.2 Trigger Metadata 

<img src='content_image/749158.jpg'>

8 rows in set (0.00 sec) 

mysql> SELECT * FROM test2; 

<img src='content_image/749159.jpg'>

8 rows in set (0.00 sec) 

mysql> SELECT * FROM test3; 

<img src='content_image/749167.jpg'>

5 rows in set (0.00 sec) 

mysql> SELECT * FROM test4; 

<img src='content_image/749160.jpg'>

10 rows in set (0.00 sec) 

To obtain metadata about triggers: 

•Query the TRIGGERS  table of the INFORMATION_SCHEMA  database. See Section 26.3.45, “The INFORMATION_SCHEMA TRIGGERS Table” . 

•Use the SHOW CREATE TRIGGER  statement. See Section 13.7.7.11, “SHOW CREATE TRIGGER Statement” . 

