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-9
SQL/MX Metadata Tables
CK_TBL_USAGE CONSTRAINT_UID
TABLE_UID
COLS OBJECT_UID
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
COL_PRIVILEGES TABLE_UID
COLUMN_NUMBER
GRANTOR
GRANTOR_TYPE
GRANTEE
GRANTEE_TYPE
PRIVILEGE_TYPE
IS_GRANTABLE
DDL_LOCKS OBJECT_UID
BASE_OBJECT_UID
TIME_LOCK_REQUESTED
TIME_LOCK_ALTERED
OPERATION
STATUS
PERCENT_COMPLETE
PROCESS_CREATE_TIME
PROCESS_ID
Table 8-1. SQL/MX Metadata Tables (page 4 of 8)
Schema Table Columns (Clustering Keys in Bold)