Title: View trigger information in the dictionary views.
Course: Database Design and Management with PL/SQL (Oracle) (10053) > Section: Creating and Removing Triggers

The following data dictionary views contain information about triggers:

- USER_TRIGGERS
- ALL_TRIGGERS
- DBA_TRIGGERS

Columns indicate the following:

- The new column, BASE_OBJECT_TYPE, specifies whether the trigger is based on DATABASE, SCHEMA, table, or view.
- The old column, TABLE_NAME, is null if the base object is not table or view.
- The column ACTION_TYPE specifies whether the trigger is a call-type trigger or a PL/SQL trigger.
- The column TRIGGER_TYPE includes two additional values: BEFORE EVENT and AFTER EVENT, applicable only to system events.
- The column TRIGGERING_EVENT includes all system and DML events.