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

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-13
ACCESS_PATH_COLS Table
ACCESS_PATH_COLS Table
ACCESS_PATH_COLS is a metadata table in
DEFINITION_SCHEMA_VERSION_vernum that describes columns within each
access paths for the catalog:
CK_COL_USAGE Table
CK_COL_USAGE is a metadata table in DEFINITION_SCHEMA_VERSION_vernum
that lists columns referenced by search conditions of check constraints in the catalog.
CK_TBL_USAGE Table
CK_TBL_USAGE is a metadata table in DEFINITION_SCHEMA that lists tables
referenced by search conditions of check constraints in the catalog.
Column Name Data Type Description
*1 ACCESS_PATH_UID LARGEINT UID of access path
*2 POSITION_IN_ROW INT Ordinal of column within access path
(first position is 0)
3 COLUMN_NUMBER INT Position within row of base table
(first column is 0)
4 ORDERING CHAR(2) A if ascending order
D if descending order
5 PART_KEY_SEQ_NUM INT Order in partitioning key (0 if not in
key)
6 CLUSTERING_KEY_SEQ_NUM INT Order in clustering key (0 if not in
key)
7 SYSTEM_ADDED_COLUMN CHAR(2) Y if system added the column
N if user added the column
* Indicates primary key
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 TABLE_UID LARGEINT UID of table with referenced column
*3 COLUMN_NUMBER INT Column position in table (first column is 0)
4 SELECTS CHAR(2) Y if column is subject of a SELECT query in
constraint definition
N if not
* Indicates primary key
Column Name Data Type Description
*1 CONSTRAINT_UID LARGEINT UID of constraint
*2 TABLE_UID LARGEINT UID of table with referenced column
* Indicates primary key