SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-34
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.
The primary key consists of the columns in the following order:
1. TRIGGER_UID
2. OTHER_SCHEMA_UID
TRIGGER_USED Table
TRIGGER_USED is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that contains Information on how triggers use objects. It serves three purposes:
•
Given a table, return all the triggers of a certain operation that are defined on that
table. Those triggers might be in other catalogs.
•
For every local object (table or view), check if a trigger anywhere is using it. This
query also describes how the trigger is using the object (for example, SELECT),
and might be needed to determine if and how a table has been used or modified.
•
For an UPDATE trigger on explicit columns in the subject table, only the
TRIGGER_USED table keeps the list of those columns (a row for each column).
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
1 TRIGGER_CATALOG_UID LARGEINT UID of trigger's catalog
2 TRIGGER_SCHEMA_UID LARGEINT UID of trigger's schema
*3 TRIGGER_UID LARGEINT UID of trigger object
*4 USED_OBJECT_UID LARGEINT UID of the local object used by the
trigger
*5 USED_COL_NUM INT The column number in
USED_OBJECT_UID. When there
is no specific column, the value is 1.