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. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.