Oracle: SQL query to find all the triggers belonging to the tables?

Sql Problem Overview

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

Check out ALL_TRIGGERS:

Another table that is useful is:

SELECT * FROM user_objects WHERE object_type='TRIGGER';

You can also use this to query views, indexes etc etc

Use the Oracle documentation and search for keyword "trigger" in your browser.

This approach should work with other metadata type questions.

Content Type	Original Author	Original Content on Stackoverflow
Question	Rajesh Kumar G	View Question on Stackoverflow
Solution 1 - Sql	yanjost	View Answer on Stackoverflow
Solution 2 - Sql	a_horse_with_no_name	View Answer on Stackoverflow
Solution 3 - Sql	diagonalbatman	View Answer on Stackoverflow
Solution 4 - Sql	tbone	View Answer on Stackoverflow

Content Type

Original Author

Original Content on Stackoverflow

Question

Solution 1 - Sql

Solution 2 - Sql