B.16 Content of SQL_KEY_COLUMN_USAGE
SQL_KEY_COLUMN_USAGE stores information related to columns that comprise primary keys and foreign keys. Each row stores information on one column comprising a primary key and foreign keys.
The following table describes the content of SQL_KEY_COLUMN_USAGE.
|
No. |
Column name |
Data type |
Stored information |
|---|---|---|---|
|
1 |
CONSTRAINT_SCHEMA |
VARCHAR(100) |
Schema name including a constraint |
|
2 |
CONSTRAINT_NAME |
VARCHAR(100) |
Constraint name |
|
3 |
TABLE_SCHEMA |
VARCHAR(100) |
Schema name of the table for which the constraint is defined |
|
4 |
TABLE_NAME |
VARCHAR(100) |
Table identifier of the table for which the constraint is defined |
|
5 |
COLUMN_NAME |
VARCHAR(100) |
Column name of the column for which the constraint is defined |
|
6 |
COLUMN_ORDER |
SMALLINT |
Definition order of column for which the constraint is defined |