| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 | 
 | 
| 
 | View PDF | 
ALL_INTERNAL_TRIGGERS describes internal triggers on tables accessible to the current user. Internal triggers are internal pieces of code executed when a particular flag is set for a table. This view does not display the OWNER_NAME column.
Related Views
DBA_INTERNAL_TRIGGERS describes internal triggers on all tables in the database.
USER_INTERNAL_TRIGGERS describes all internal triggers on tables owned by the current user. This view does not display the OWNER_NAME column.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| TABLE_NAME | VARCHAR2(30) | Name of the table on which the trigger is defined | |
| OWNER_NAME | VARCHAR2(30) | Owner of the table | |
| INTERNAL_TRIGGER_TYPE | VARCHAR2(19) | Indicates the type of internal trigger on the table |