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-8
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 2 of 3)
VST006.vsd
DEFINITION_SCHEMA_VERSION_3100
ACCESS_PATHS
PK TABLE_UID
PK ACCESS_PATH_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
ROW_FORMAT
INSERT_MODE
MAX_TABLE_SIZE
RESERVED_FILLER_INT
RESERVED_FILLER_CHAR
DISK_POOL
NUM_DISK_POOL
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
DATE_DISPLAY_FORMAT
CASE_SENSITIVE_COMPARISON
DISPLAY_DATA_TYPE
RESERVED_FILLER_INT
RESERVED_FILLER_CHAR
KEY_COL_USAGE
PK CONSTRAINT_UID
PK COLUMN_NUMBER
ORDINAL_POSITION
MP_PARTITIONS
PK OBJECT_UID
MPPARTITION_NAME
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
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
RESERVED_FILLER_INT
RESERVED_FILLER_CHAR
DROPPABLE
RCB_VERSION
REF_CONSTRAINTS
PK CONSTRAINT_UID
UNIQUE_CONSTRAINT_CAT_UID
UNIQUE_CONSTRAINT_SCH_UID
UNIQUE_CONSTRAINT_UID
MATCH_OPTION
UPDATE_RULE
DELETE_RULE