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

how can i find all the tr开发者_高级运维iggers 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

or

select * from USER_TRIGGERS

---

Check out ALL_TRIGGERS:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2107.htm#i1592586

---

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.