SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—544536-007
8-10
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 4 of 4)
VST008.vsd
DEFINITION_SCHEMA_VERSION_1200
TEXT
PK OBJECT_UID
PK OBJECT_SUB_ID
PK SEQUENCE_NUM
TEXT
TRIGGERS
PK TRIGGER_UID
SUBJECT_CATALOG_UID
SUBJECT_SCHEMA_UID
SUBJECT_UID
ACTIVATION_TIME
OPERATION
GRANULARITY
COLUMNS_IMPLICIT
ENABLED
TRIGGER_CREATED
TRIGGERS_CAT_USAGE
PK TRIGGER_UID
PK OTHER_SCHEMA_UID
OTHER_CATALOG_UID
TRIGGER_USED
PK TRIGGER_UID
PK USED_OBJECT_UID
PK USED_COL_NUM
PK OPERATION
PK IS_SUBJECT_TABLE
TRIGGER_CATALOG_UID
TRIGGER_SCHEMA_UID
VWS
PK OBJECT_UID
CHECK_OPTION
IS_UPDATABLE
IS_INSERTABLE
VW_COL_TBLS
PK VIEW_UID
PK VIEW_COL_NUM
PK UNDERLYING_CAT_UID
PK UNDERLYING_SCH_UID
PK UNDERLYING_OBJ_UID
VW_COL_TBL_COLS
PK VIEW_UID
PK VIEW_COL_NUM
PK UNDERLYING_CAT_UID
PK UNDERLYING_SCH_UID
PK UNDERLYING_OBJ_UID
PK UNDERLYING_COL_NUM
VW_COL_USAGE
PK USING_VIEW_UID
PK USED_CAT_UID
PK USED_SCH_UID
PK USED_OBJ_UID
PK COLUMN_NUMBER
VW_TBL_USAGE
PK USING_VIEW_UID
PK USED_OBJ_UID
PK VIEW_CATALOG_UID
PK USED_OBJ_CATALOG_UID
VIEW_SCHEMA_UID
USED_OBJ_SCHEMA_UID