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-9
SQL/MX Metadata Tables
Figure 8-2. SQL/MX Metadata Tables (page 3 of 3)
VST007.vsd
DEFINITION_SCHEMA_VERSION_3100
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
REPLICAS
PK OBJECT_UID
PK SYSTEM_NAME
PK DATA_SOURCE
PK FILE_SUFFIX
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
RI_UNIQUE_USAGE
PK UNIQUE_CONSTRAINT_UID
PK FOREIGN_KEY_CATALOG_UID
PK FOREIGN_KEY_SCHEMA_UID
PK FOREIGN_KEY_UID
TBL_CONSTRAINTS
PK TABLE_UID
PK CONSTRAINT_UID
PK CONSTRAINT_TYPE
DISABLED
DROPPABLE
IS_DEFERRABLE
INITIALLY_DEFERRABLE
INDEX_UID
ENFORCED
VALIDATED
LAST_VALIDATED
TBL_PRIVILEGES
PK TABLE_UID
PK GRANTOR
PK GRANTOR_TYPE
PK GRANTEE
PK GRANTEE_TYPE
PK PRIVILEGE_TYPE
IS_GRANTABLE
TEXT
PK OBJECT_UID
PK OBJECT_SUB_ID
PK SEQUENCE_NUM
TEXT
TRIGGERS
PK TRIGGER_UID
SUBJECT_CATALOG_UID
SUBJECT_SCHEMA_UID
SUBJECT_UID
ACTIVATION_TIME
OPERATION
GRANULARITY
COLUMNS_IMPLICIT
ENABLED
TRIGGER_CREATED
TRIGGERS_CAT_USAGE
PK TRIGGER_UID
PK OTHER_SCHEMA_UID
OTHER_CATALOG_UID
TRIGGER_USED
PK USED_OBJECT_UID
PK USED_COL_NUM
PK OPERATION
PK IS_SUBJECT_TABLE
PK TRIGGER_UID
TRIGGER_CATALOG_UID
TRIGGER_SCHEMA_UID
VWS
PK OBJECT_UID
CHECK_OPTION
IS_UPDATABLE
IS_INSERTABLE
VW_COL_USAGE
PK USING_VIEW_UID
PK USED_CAT_UID
PK USED_SCH_UID
PK USED_OBJ_UID
PK COLUMN_NUMBER
VW_TBL_USAGE
PK USING_VIEW_UID
PK USED_OBJ_UID
PK VIEW_CATALOG_UID
PK USED_OBJ_CATALOG_UID
VIEW_SCHEMA_UID
USED_OBJ_SCHEMA_UID
VW_COL_TBL_COLS
PK VIEW_UID
PK VIEW_COL_NUM
PK UNDERLYING_CAT_UID
PK UNDERLYING_SCH_UID
PK UNDERLYING_OBJ_UID
PK UNDERLYING_COL_NUM