KEY_COLUMN_USAGE
This page is part of MariaDB's Documentation.
The parent of this page is: Information Schema for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Information-schema Table has not yet been added to this Documentation.
USAGE
DETAILS
SYNONYMS
SCHEMA
CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` (
`CONSTRAINT_CATALOG` varchar(512) NOT NULL,
`CONSTRAINT_SCHEMA` varchar(64) NOT NULL,
`CONSTRAINT_NAME` varchar(64) NOT NULL,
`TABLE_CATALOG` varchar(512) NOT NULL,
`TABLE_SCHEMA` varchar(64) NOT NULL,
`TABLE_NAME` varchar(64) NOT NULL,
`COLUMN_NAME` varchar(64) NOT NULL,
`ORDINAL_POSITION` bigint(10) NOT NULL,
`POSITION_IN_UNIQUE_CONSTRAINT` bigint(10),
`REFERENCED_TABLE_SCHEMA` varchar(64),
`REFERENCED_TABLE_NAME` varchar(64),
`REFERENCED_COLUMN_NAME` varchar(64)
)
PARAMETERS
SKYSQL
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
RELATED TOPICS
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.