---
title: "查看触发器信息 | OceanBase 文档中心"
description: 查看触发器信息 触发器详细信息可以通过 USER_TRIGGERS 视图查看，包括名称、类型、作用的表等。 示例 1：列出 当前用户所 有的触发器，包括类型、状态和作用的表及其用户。 obclient>SELECT TRIGGER_NAME,TRIGGER_TYPE,TRIGGERING_EVENT,TABLE_OW…
image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original
---
切换语言

- 中文站 - 简体中文
- International - English
- 日本站 - 日本語

文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 2.2.77 企业版 LTS

# 查看触发器信息

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

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

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

```javascript
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`** **的定义内容。**

```sql
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)

```

 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线