SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—640325-001
8-5
SQL/MX Metadata Tables
SQL/MX Metadata Tables
Figure 8-1 shows the SQL/MX metadata table structure.
Some important concepts to note are:
Figure 8-1. SQL/MX Metadata Table Structure
VST004.vsd
NONSTOP_SQLMX_nodename
Catalog
Note: User catalogs
are not shown.
SYSTEM_DEFAULTS_SCHEMA
SYSTEM_SQLJ_SHCEMADEFINITION_SCHEMA_VERSION_3000
SYSTEM_SCHEMA MXCS_SCHEMA
SYSTEM_DEFAULTS
CATSYS
CAT_REFERENCES
SCEMATA
SCEMA_REPLICAS
ASSOC2DS
DATASOURCES
ENVIRONMENTVALUES
NAME2ID
RESOURCEPOLICIES
Schemas
Tables
~
~
~
~
ACCESS_PATHS
ACCESS_PATH_COLS
CK_COL_USAGE
CK_TBL_USAGE
COLS
COL_PRIVILEGES
DDL_LOCKS
KEY_COL_USAGE
MP_PARTITIONS
OBJECTS
PARTITIONS
REF_CONSTRAINTS
REPLICAS
RI_UNIQUE_USAGE
ROUTINES
TBL_CONSTRAINTS
TBL_PRIVILEGES
TEXT
TRIGGERS
TRIGGERS_CAT_USAGE
TRIGGER_USED
VWS
VW_COL_TBL_COLS
VW_COL_USAGE
VW_TBL_USAGE