SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-22
KEY_COL_USAGE Table
KEY_COL_USAGE Table
KEY_COL_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that lists columns on key constraints in the catalog. KEY_COL_USAGE contains one or
more rows for each unique, primary key, or foreign key constraint in the
TBL_CONSTRAINTS table:
MP_PARTITIONS Table
MP_PARTITIONS is a metadata table in DEFINITION_SCHEMA that stores partition
names of SQL/MP tables that have SQL/MX aliases:
OBJECTS Table
OBJECTS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that
describes tables, views, indexes, constraints, triggers, MP aliases, stored procedures,
locks, and trigger temporary tables.
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 COLUMN_NUMBER INT Position within table (first column is 0)
3 ORDINAL_POSITION INT Position within key (first column is 0)
* Indicates primary key
Column Name Data Type Description
*1 OBJECT_UID LARGEINT UID of table; link to OBJECTS
2 MPPARTITION_NAME CHAR(36) Name of NonStop SQL/MP partition
system.volume.subvolume.name
* Indicates primary key
Column Name Data Type Description
*1 SCHEMA_UID LARGEINT UID of schema; link to SCHEMATA
*2 OBJECT_NAME CHAR(128) Simple object name
*3 OBJECT_NAME_SPACE CHAR(2) Object namespace:
CN Constraint
IX Index
LK Lock
SG Internal Sequence Generator
TA Table value object (table, view,
stored procedure, SQL/MP alias)
TR Trigger
TT Trigger temp table