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-10
SQL/MX Metadata Tables
DDL_PARTITION_LOCKS OBJECT_UID
SYSTEM_NAME
DATA_SOURCE
FILE_SUFFIX
KEY_COL_USAGE CONSTRAINT_UID
COLUMN_NUMBER
ORDINAL_POSITION
MODULES MODULE_UID
PREPROCESS_TIME
REBIND_TIME
RUNTIME_COMPILE
AUTO_REBIND
REBIND_IN_PROGRESS
REBINDING_PROCESS_ID
APPLICATION_NAME
MP_PARTITIONS OBJECT_UID
MPPARTITION_NAME
MVGROUPS Reserved for future use
MVS Reserved for future use
MVS_COLS Reserved for future use
MVS_JOIN_COLS Reserved for future use
MVS_TABLE_INFO Reserved for future use
MVS_USED Reserved for future use
OBJECTS SCHEMA_UID
OBJECT_NAME
OBJECT_NAME_SPACE
OBJECT_TYPE
OBJECT_UID
CREATE_TIME
REDEF_TIME
CACHE_TIME
OBJECT_FEATURE_VERSION
VALID_DEF
OBJECT_SECURITY_CLASS
OBJECT_OWNER
Table 8-1. SQL/MX Metadata Tables (page 5 of 8)
Schema Table Columns (Clustering Keys in Bold)