SYSTRIGDEP
The SYSTRIGDEP view contains one row for each object referenced in the WHEN clause or the triggered SQL statements of a trigger.
The following table describes the columns in the SYSTRIGDEP view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
TRIGGER_SCHEMA | TRIGSCHEMA | VARCHAR(128) | Name of the schema containing the trigger. |
TRIGGER_NAME | TRIGNAME | VARCHAR(128) | Name of the trigger. |
OBJECT_SCHEMA | BSCHEMA | VARCHAR(128) | Name of the schema containing the object referenced in the trigger. |
OBJECT_NAME | BNAME | VARCHAR(128) | Name of the object referenced in the trigger. |
OBJECT_TYPE | BTYPE | CHAR(24) | Indicates the object type of the
object referenced in the trigger:
|
PARM_SIGNATURE | SIGNATURE | VARCHAR(10000) Nullable
|
This column identifies the routine
signature. Contains the null value if the object is not a routine. |
SYSTEM_TRIGGER_SCHEMA | SYS_TDNAME | CHAR(10) | System schema name. |
SYSTEM_OBJECT_SCHEMA | SYS_DNAME | CHAR(10) Nullable
|
System schema name of the object
referenced in the trigger. Contains the null value if the referenced object does not exist or if the referenced object is not an alias, index, materialized query table, table, or view. |
SYSTEM_OBJECT_NAME | SYS_ONAME | CHAR(10) Nullable
|
System object name of the object
referenced in the trigger. Contains the null value if the referenced object does not exist or if the referenced object is not an alias, index, materialized query table, table, or view. |