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

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-13
SQL/MX Metadata Tables
TRIGGERS_CAT_USAGE TRIGGER_UID
OTHER_SCHEMA_UID
OTHER_CATALOG_UID
TRIGGER_USED TRIGGER_UID
USED_OBJECT_UID
USED_COL_NUM
OPERATION
IS_SUBJECT_TABLE
TRIGGER_CATALOG_UID
TRIGGER_SCHEMA_UID
VWS OBJECT_UID
CHECK_OPTION
IS_UPDATABLE
IS_INSERTABLE
VW_COL_TBLS VIEW_UID
VIEW_COL_NUM
UNDERLYING_CAT_UID
UNDERLYING_SCH_UID
UNDERLYING_OBJ_UID
VW_COL_TBL_COLS VIEW_UID
VIEW_COL_NUM
UNDERLYING_CAT_UID
UNDERLYING_SCH_UID
UNDERLYING_OBJ_UID
UNDERLYING_COL_NUM
VW_COL_USAGE USING_VIEW_UID
USED_CAT_UID
USED_SCH_UID
USED_OBJ_UID
COLUMN NUMBER
VW_TBL_USAGE USING_VIEW_UID
USED_OBJ_UID
VIEW_CATALOG_UID
USED_OBJ_CATALOG_UID
VIEW_SCHEMA_UID
USED_OBJ_SCHEMA_UID
Table 8-1. SQL/MX Metadata Tables (page 8 of 8)
Schema Table Columns (Clustering Keys in Bold)