Feature
This view provides information about key columns that have constraints.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| CONSTRAINT_CATALOG | varchar(3) | NO | The name of the catalog to which the constraint belongs. The value of this field is always def. |
| CONSTRAINT_SCHEMA | varchar(128) | NO | The name of the database. |
| CONSTRAINT_NAME | varchar(7) | NO | The name of the constraint. The value of this field is PRIMARY, the column name, or the foreign key name. |
| TABLE_CATALOG | varchar(3) | NO | The name of the catalog to which the table belongs. |
| TABLE_SCHEMA | varchar(128) | NO | The name of the database. |
| TABLE_NAME | varchar(256) | NO | The name of the table. |
| COLUMN_NAME | varchar(128) | NO | The name of the column. |
| ORDINAL_POSITION | bigint(20) | NO | The serial number of the column within the table. |
| POSITION_IN_UNIQUE_CONSTRAINT | null | NO | The value of this field is NULL for unique key and primary key constraints. For foreign key constraints, the value of this field is the ordinal position in the key of the table that is being referenced. |
| REFERENCED_TABLE_SCHEMA | varchar(128) | NO | The name of the database referenced by the constraint. |
| REFERENCED_TABLE_NAME | varchar(256) | NO | The name of the table referenced by the constraint. |
| REFERENCED_COLUMN_NAME | varchar(128) | NO | The name of the column referenced by the constraint. |