KEY_COLUMN_USAGE
Records columns in an index or in a primary, unique or foreign key.
Column name
|
Data type
|
Description
|
TABLE_SYSID
|
INTEGER
|
System identifier for the table. |
CONSTRAINT_SYSID
|
INTEGER
|
System identifier for the table column. |
ORDINAL_POSITION
|
INTEGER
|
The ordinal position of the column in the table. The first column in the table is number 1. |
COLUMN_NAME
|
VARCHAR(128)
|
The name of the table column. |
KEY_TYPE
|
CHAR(20)
|
One of:
"PRIMARY_KEY"
"UNIQUE"
"FOREIGN KEY"
"INDEX"
"INTERNAL_KEY". |
IS_UNIQUE
|
CHAR(3)
|
One of:
"NO" = unique values are permitted in the column
"YES" = the column is constrained to contain only unique values. |
IS_ASCENDING
|
CHAR(3)
|
One of: "NO" = the column is indexed in descending value order
"YES" = the column is indexed in ascending value order. |
Primary key: TABLE_SYSID, CONSTRAINT_SYSID, ORDINAL_POSITION
Unique constraint: CONSTRAINT_SYSID, COLUMN_NAME
