Information on primary key and UNIQUE constraints belonging to the current authorization identifier, as well as the name of the corresponding columns.
This view also contains information on referential constraints belonging to the current authorization identifier, as well as the names of the referencing columns.
Column name |
Data type |
Contents |
CONSTRAINT_CATALOG |
CHAR (18) |
Database name |
CONSTRAINT_SCHEMA |
CHAR (31) |
Name of the schema to which the table |
CONSTRAINT_NAME |
CHAR (31) |
Name of the integrity constraint |
TABLE_CATALOG |
CHAR (18) |
Database name |
TABLE_SCHEMA |
CHAR (31) |
Name of the schema to which the table |
TABLE_NAME |
CHAR (31) |
Name of the table to which the integrity |
COLUMN_NAME |
CHAR (31) |
Name of a column in the integrity |
ORDINAL_POSITION |
SMALLINT |
Position of the column in the integrity |
Table 76: KEY_COLUMN_USAGE view of the INFORMATION_SCHEMA