Each row represents a column that participates in a key defined by a unique, primary key, or foreign key constraint.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
CONSTNAME | VARCHAR (128) | Name of the constraint. | |
TABSCHEMA | VARCHAR (128) | Schema name of the table containing the column. | |
TABNAME | VARCHAR (128) | Unqualified name of the table containing the column. | |
COLNAME | VARCHAR (128) | Name of the column. | |
COLSEQ | SMALLINT | Numeric position of the column in the key for the constraint (initial position is 1). If a constraint uses an existing index, this value is the numeric position of the column in the index. |