SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-20
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:
*3 DATA_SOURCE CHAR(8) Name of a volume. The volume name includes
the leading '$' sign.
*4 FILE_SUFFIX CHAR(18) Subvol and simple name.
* Indicates primary key
Note. The DDL_PARTITION_LOCKS table is not present in schema version 3000 and newer
system schemas.
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