Oracle:SQL查询以查找属于该表的所有触发器? [英] Oracle: SQL query to find all the triggers belonging to the tables?

问题描述

我如何找到属于一个表的所有触发器?

how can i find all the triggers that belong to a table?

推荐答案

以下内容将独立于您的数据库特权运行:

The following will work independent of your database privileges:

select * from all_triggers
where table_name = 'YOUR_TABLE'

以下替代选项可能会起作用，也可能不会起作用，具体取决于您分配的数据库特权:

The following alternate options may or may not work depending on your assigned database privileges:

select * from DBA_TRIGGERS

或

select * from USER_TRIGGERS

这篇关于Oracle:SQL查询以查找属于该表的所有触发器?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！