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-8
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 2 of 4)
VST006.vsd
DEFINITION_SCHEMA_VERSION_1200
ACCESS_PATHS
PK ACCESS_PATH_UID
TABLE_UID
ACCESS_PATH_TYPE
COLUMN_COUNT
UNIQUE_COLUMN_COUNT
VALID_DATA
RECORD_SIZE
UNIQUES
EXPLICIT
CLUSTERING_SCHEME
PARTITIONING_SCHEME
BLOCK_SIZE
KEY_LENGTH
PARTITIONING_KEY_LENGTH
LOCK_LENGTH
AUDITED
AUDIT_COMPRESS
CLEAR_ON_PURGE
BUFFERED
RECORD_PACKED
DATA_COMPRESSED
INDEX_COMPRESSED
PACKING_SCHEME
PACKING_FACTOR
ALL_COLUMNS_INCLUDED
COLS
PK OBJECT_UID
PK COLUMN_NUMBER
DIRECTION
COLUMN_CLASS
COLUMN_NAME
COLUMN_SIZE
SQL_DATA_TYPE
CHARACTER_SET
ENCODING
COLLATION_SEQUENCE
FS_DATA_TYPE
COL_SCALE
COL_PRECISION
UPSHIFTED
NULL_HEADER_SIZE
VARLEN_HEADER_SIZE
DEFAULT_CLASS
LOGGABLE
DATETIME_START_FIELD
DATETIME_END_FIELD
DATETIME_LEADING_PRECISION
DATETIME_TRAILING_PRECISION
DATETIME_QUALIFIER
DEFAULT_VALUE
HEADING_TEXT
PICTURE_TEXT
COLUMN_VALUE_DRIFT_PER_DAY
KEY_COL_USAGE
PK CONSTRAINT_UID
PK COLUMN_NUMBER
ORDINAL_POSITION
MODULES
PK MODULE_UID
PREPROCESS_TIME
REBIND_TIME
RUNTIME_COMPILE
AUTO_REBIND
REBIND_IN_PROGRESS
REBINDING_PROCESS_ID
APPLICATION_NAME
MP_PARTITIONS
PK OBJECT_UID
MPPARTITION_NAME
MVGROUPS
PK MVRGROUP_UID
PK MV_UID
MVRGROUP_SCHEMA_UID
MVRGROUP_CATALOG_UID
MV_SCHEMA_UID
MV_CATALOG_UID
MVS
PK MV_UID
REFRESHED_AT
COMMIT_REFRESH_EACH
MV_TYPE
REWRITE_ENABLED
LEFT_LINEAR
INCREMENTALY_MAINTAINABLE
CREATION_REFRESH_TYPE
CONTAINS_MVS
MVSTATUS
IS_MINMAX
MV_AUDIT
MV_ATTRIBUTES
ACCESS_PATH_COLS
PK ACCESS_PATH_UID
PK POSITION_IN_ROW
COLUMN_NUMBER
ORDERING
PART_KEY_SEQ_NUM
CLUSTERING_KEY_SEQ_NUM
SYSTEM_ADDED_COLUMN
CK_COL_USAGE
PK CONSTRAINT_UID
PK TABLE_UID
PK COLUMN_NUMBER
SELECTS
CK_TBL_USAGE
PK CONSTRAINT_UID
PK TABLE_UID
COL_PRIVILEGES
PK TABLE_UID
PK COLUMN_NUMBER
PK GRANTOR
PK GRANTOR_TYPE
PK GRANTEE
PK GRANTEE_TYPE
PK PRIVILEGE_TYPE
IS_GRANTABLE
DDL_LOCKS
PK OBJECT_UID
BASE_OBJECT_UID
TIME_LOCK_REQUESTED
TIME_LOCK_ALTERED
OPERATION
STATUS
PERCENT_COMPLETE
PROCESS_CREATE_TIME
PROCESS_ID
DDL_PARTITION_LOCKS
PK PK OBJECT_UID
PK SYSTEM_NAME
PK DATA_SOURCE
PK FILE_SUFFIX