SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-26
TRIGGERS_CAT_USAGE Table
TRIGGERS_CAT_USAGE Table
TRIGGERS_CAT_USAGE is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that describes a trigger's use of objects in
other catalogs (primarily needed for the DROP TRIGGER statement). Triggers can
access objects in different (“foreign”) catalogs than the catalog of the trigger itself.
4 SUBJECT_UID LARGEINT UID of the table on which the trigger
is defined
5 ACTIVATION_TIME CHAR(2) Activation time:
B Before
A After
6 OPERATION CHAR(2) Operation that fires the trigger:
I INSERT
D DELETE
U UPDATE
7 GRANULARITY CHAR(2) Granularity:
R Row
S Statement
8 COLUMNS_IMPLICIT CHAR(2) Relevant only for UPDATE trigger:
Y Yes
N No
9 ENABLED CHAR(2) Current status of trigger:
Y if enabled
N if not
10 TRIGGER_CREATED LARGEINT Timestamp of creation of the trigger
* Indicates primary key
Column Name Data Type Description
*1 TRIGGER_UID LARGEINT UID of trigger object
2 OTHER_CATALOG_UID LARGEINT UID of the foreign catalog containing
schemas containing objects used by
this trigger
*3 OTHER_SCHEMA_UID LARGEINT UID of the foreign schema
containing objects used by this
trigger
* Indicates primary key
Column Name Data Type Description