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:

Table 135. 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:
ALIAS
The object is an alias.
FUNCTION
The object is a function.
INDEX
The object is an index.
MATERIALIZED QUERY TABLE
The object is a materialized query table.
PACKAGE
The object is a package.
PROCEDURE
The object is a procedure.
SCHEMA
The object is a schema.
SEQUENCE
The object is a sequence.
TABLE
The object is a table.
TYPE
The object is a distinct type.
VIEW
The object is a view.
PARM_SIGNATURE SIGNATURE VARCHAR(10000)
Nullable
This column identifies the routine signature.

Contains the null value if the object is not a routine.