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-11
SQL/MX Metadata Tables
PARTITIONS OBJECT_UID
SYSTEM_NAME
DATA_SOURCE
FILE_SUFFIX
PARTITION_NAME
MAX_SIZE
PRI_EXT
SEC_EXT
MAX_EXT
INDEX_LEVEL
NON_EMPTY_BLOCK_COUNT
EOF
PARTITION_STATUS
DDL_IN_PROGRESS
FIRST_KEY
ENCODED_KEY
PARTITION_DROP_TIME
REF_CONSTRAINTS CONSTRAINT_UID
UNIQUE_CONSTRAINT_CAT_UID
UNIQUE_CONSTRAINT_SCH_UID
UNIQUE_CONSTRAINT_UID
MATCH_OPTION
UPDATE_RULE
DELETE_RULE
REPLICAS OBJECT_UID
SYSTEM_NAME
DATA_SOURCE
FILE_SUFFIX
RI_UNIQUE_USAGE UNIQUE_CONSTRAINT_UID
FOREIGN_KEY_CATALOG_UID
FOREIGN_KEY_SCHEMA_UID
FOREIGN_KEY_UID
Table 8-1. SQL/MX Metadata Tables (page 6 of 8)
Schema Table Columns (Clustering Keys in Bold)