Spec-Zone .ru
спецификации, руководства, описания, API

20.11. The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table

The KEY_COLUMN_USAGE table describes which key columns have constraints.

INFORMATION_SCHEMA Name SHOW Name Remarks
CONSTRAINT_CATALOG def
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
TABLE_CATALOG def
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
POSITION_IN_UNIQUE_CONSTRAINT
REFERENCED_TABLE_SCHEMA
REFERENCED_TABLE_NAME
REFERENCED_COLUMN_NAME

Notes: