## MD_TRIGGERS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | PK | COMMENTS
--- | --- | --- | --- | --- | --- | ---
ID | NUMBER | No | null | 1 | 1 | Primary Key
TABLE_OR_VIEW_ID_FK | NUMBER | No | null | 2 | null | Table on which this trigger fires
TRIGGER_ON_FLAG | CHAR(1 BYTE) | No | null | 3 | null | Flag to show iif the trigger is on a table or a view. If it is a table this should be 'T'. If it is on a view this should be 'V'
TRIGGER_NAME | VARCHAR2(4000 BYTE) | Yes | null | 4 | null | Name of the trigger //OBJECTNAME
TRIGGER_TIMING | VARCHAR2(4000 BYTE) | Yes | null | 5 | null | before, after ,etc.
TRIGGER_OPERATION | VARCHAR2(4000 BYTE) | Yes | null | 6 | null | insert, delete, etc.
TRIGGER_EVENT | VARCHAR2(4000 BYTE) | Yes | null | 7 | null | The actual trigger that gets fired
NATIVE_SQL | CLOB | Yes | null | 8 | null | The full definition
NATIVE_KEY | VARCHAR2(4000 BYTE) | Yes | null | 9 | null | UInique identifer for this object at source
LANGUAGE | VARCHAR2(40 BYTE) | No | null | 10 | null | //PUBLIC
COMMENTS | VARCHAR2(4000 BYTE) | Yes | null | 11 | null | null
SECURITY_GROUP_ID | NUMBER | No | 0 | 12 | null | null
CREATED_ON | DATE | No | sysdate | 13 | null | null
CREATED_BY | VARCHAR2(255 BYTE) | Yes | null | 14 | null | null
LAST_UPDATED_ON | DATE | Yes | null | 15 | null | null
LAST_UPDATED_BY | VARCHAR2(255 BYTE) | Yes | null | 16 | null | null