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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-27
TRIGGER_USED Table
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_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.
*6 OPERATION CHAR(2) Operation that fires the trigger
U UPDATE
I INSERT
D DELETE
For the used-object only, the
operation performed on the used
object
S SELECT
R ROUTINE
*7 IS_SUBJECT_TABLE CHAR(2) Y if the USED_OBJECT_UID is the
subject table of this trigger
N if the USED_OBJECT_UID is
used only by this trigger
* Indicates primary key