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

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—544536-007
8-9
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 3 of 4)
VST007.vsd
DEFINITION_SCHEMA_VERSION_1200
MVS_COLS
PK MV_UID
PK ORIGINAL_TABLE_UID
PK MV_COL_NUM
PK ORIGINAL_COL_NUM
PK USAGE_TYPE
ORIGINAL_TABLE_CATALOG_UID
ORIGINAL_TABLE_SCHEMA_UID
DEPENDENT_COL_1
DEPENDENT_COL_2
DEPENDENT_COL_3
COLUMN_TYPE
OPERATOR_TYPE
IS_COMPLEX
IS_USED_BY_JOIN
IS_SYSTEM
MVS_JOIN_COLS
PK MV_UID
PK SEQ_NUMBER
PK USAGE_TYPE
TABLE_CATALOG_UID
TABLE_SCHEMA_UID
TABLE_UID
COL_NUM
VEG_INDEX
IS_COMPLEX
LEFT_JOIN_TABLE_TYPE
MVS_TABLE_INFO
PK BASE_TABLE_UID
CURRENT_EPOCH
MV_ATTRIBUTES_BITMAP
IS_LOCKONREFRESH
IS_INSERTLOG
RANGELOG_TYPE
MVSALLOWED_TYPE
MVS_USED
PK MV_UID
PK USED_OBJECT_UID
PK USABLE_ORIGIN
MV_SCHEMA_UID
MV_CATALOG_UID
USED_OBJECT_SCHEMA_UID
USED_OBJECT_CATALOG_UID
ORDINAL_NUMBER
TABLE_ATTRIBUTES
USED_OBJECT_TYPE
IS_INNER_LJ
PREDICATES
OBJECTS
PK SCHEMA_UID
PK OBJECT_NAME
PK OBJECT_NAME_SPACE
OBJECT_TYPE
OBJECT_UID
CREATE_TIME
REDEF_TIME
CACHE_TIME
OBJECT_FEATURE_VERSION
VALID_DEF
OBJECT_SECURITY_CLASS
OBJECT_OWNER
PARTITIONS
PK OBJECT_UID
PK SYSTEM_NAME
PK DATA_SOURCE
PK 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
PK CONSTRAINT_UID
UNIQUE_CONSTRAINT_CAT_UID
UNIQUE_CONSTRAINT_SCH_UID
UNIQUE_CONSTRAINT_UID
MATCH_OPTION
UPDATE_RULE
DELETE_RULE
REPLICAS
PK OBJECT_UID
PK SYSTEM_NAME
PK DATA_SOURCE
PK FILE_SUFFIX
RI_UNIQUE_USAGE
PK UNIQUE_CONSTRAINT_UID
PK FOREIGN_KEY_CATALOG_UID
PK FOREIGN_KEY_SCHEMA_UID
PK FOREIGN_KEY_UID
ROUTINES
PK UDR_UID
UDR_TYPE
LANGUAGE_TYPE
DETERMINISTIC_BOOL
SQL_ACCESS
CALL_ON_NULL
ISOLATE_BOOL
PARAM_STYLE
EXTRA_CALL
TRANSACTION_ATTRIBUTES
MAX_RESULTS
STATE_AREA_SIZE
UDR_ATTRIBUTES
EXTERNAL_PATH
EXTERNAL_FILE
EXTERNAL_NAME
TBL_CONSTRAINTS
PK CONSTRAINT_UID
PK CONSTRAINT_TYPE
PK TABLE_UID
DISABLED
DROPPABLE
IS_DEFERRABLE
INITIALLY_DEFERRABLE
INDEX_UID
TBL_PRIVILEGES
PK GRANTOR
PK GRANTOR_TYPE
PK GRANTEE
PK GRANTEE_TYPE
PK TABLE_UID
PK PRIVILEGE_TYPE
IS_GRANTABLE