information_schema.key_column_usage.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
key_column_usage |
||||||||
column_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_name |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
constraint_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
ordinal_position |
BIGINT NOT NULL:
5.7-8
| BIGINT NOT NULL:
NULL:
| BIGINT(10) NOT NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| INT NULL:
| |||
position_in_unique_constraint |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(10) NULL:
| CARDINAL_NUMBER:
CARDINAL_NUMBER NULL:
| unsupported | |||
referenced_column_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
referenced_table_name |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
referenced_table_schema |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NOT NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||