编组

查看触发器信息

更新时间：2023-07-18 17:27:23

触发器详细信息可以通过 USER_TRIGGERS 视图查看，包括名称、类型、作用的表等。

示例 1：列出 当前用户所 有的触发器，包括类型、状态和作用的表及其用户。

obclient>SELECT TRIGGER_NAME,TRIGGER_TYPE,TRIGGERING_EVENT,TABLE_OWNER,TABLE_NAME,
               STATUS FROM user_triggers;
+----------------+-----------------+------------------+-------------+------------+---------+
| TRIGGER_NAME   | TRIGGER_TYPE    | TRIGGERING_EVENT | TABLE_OWNER | TABLE_NAME | STATUS  |
+----------------+-----------------+------------------+-------------+------------+---------+
| DEL_NEW_REGION | BEFORE EACH ROW | DELETE           | SYS         | REGIONS    | ENABLED |
+----------------+-----------------+------------------+-------------+------------+---------+
1 row in set (0.05 sec)

示例 2：查看 触发器 DEL_NEW_REGION 的定义内容。

obclient>SELECT TRIGGER_BODY FROM user_triggers 
               WHERE TRIGGER_NAME='DEL_NEW_REGION'\G
*************************** 1. row ***************************
TRIGGER_BODY: TRIGGER del_new_region
   BEFORE DELETE ON regions
   FOR EACH ROW
   WHEN (old.region_id >3)
BEGIN
   INSERT INTO reg_his(region_id , region_name )
       VALUES( :old.region_id, :old.region_name );
END
1 row in set (0.00 sec)