SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-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_SCHEMADEFINITION_SCHEMA_VERSION_3100
SYSTEM_SCHEMA MXCS_SCHEMA
SYSTEM_DEFAULTS
CATSYS
CAT_REFERENCES
SCHEMATA
SCHEMA_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
PRIVILEGED_USERS
MGM_PRIVILEGES
SYSTEM_SECURITY_SCHEMA