Have Geek Brain

How can I get all the triggers associated with a specific table?

I am looking for a way to get all triggers where there is an action associated with a specific table. I don't want to read manually all the triggers I have on the server as there are too many of them.

Any ideas?

+2


a source to share


2 answers 


SELECT * FROM USER_TRIGGERS WHERE TABLE_NAME = 'NAME_OF_YOUR_TABLE';


+7


a source


If you mean what Peter Lang pointed out, look at the dba_dependencies view (or all_dependencies or user_dependencies, of course).



0


a source






More articles:


All Articles