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-12
SQL/MX Metadata Tables
ROUTINES 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 CONSTRAINT_UID
CONSTRAINT_TYPE
TABLE_UID
DISABLED
DROPPABLE
IS_DEFERRABLE
INITIALLY_DEFERRABLE
INDEX_UID
TBL_PRIVILEGES GRANTOR
GRANTOR_TYPE
GRANTEE
GRANTEE_TYPE
TABLE_UID
PRIVILEGE_TYPE
IS_GRANTABLE
TEXT OBJECT_UID
OBJECT_SUB_ID
SEQUENCE_NUM
TEXT
TRIGGERS TRIGGER_UID
SUBJECT_CATALOG_UID
SUBJECT_SCHEMA_UID
SUBJECT_UID
ACTIVATION_TIME
OPERATION
GRANULARITY
COLUMNS_IMPLICIT
ENABLED
TRIGGER_CREATED
Table 8-1. SQL/MX Metadata Tables (page 7 of 8)
Schema Table Columns (Clustering Keys in Bold)