information_schema
.referential_constraints
.*
relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
---|---|---|---|---|---|---|---|---|
referential_constraints |
||||||||
constraint_catalog |
VARCHAR NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| NVARCHAR(128) NULL :
| |||
constraint_name |
VARCHAR NOT NULL :
5.7
VARCHAR NULL :
8
| VARCHAR NOT NULL :
NULL :
| unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| SYSNAME NULL :
| |||
constraint_schema |
VARCHAR NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| NVARCHAR(128) NULL :
| |||
delete_rule |
ENUM NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| VARCHAR(11) NULL :
| |||
match_option |
ENUM NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| VARCHAR(7) NULL :
| |||
referenced_table_name |
VARCHAR NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | unsupported | unsupported | |||
table_name |
VARCHAR NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | unsupported | unsupported | |||
unique_constraint_catalog |
VARCHAR NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| NVARCHAR(128) NULL :
| |||
unique_constraint_name |
VARCHAR NULL :
5.7-8
| NULL :
| unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| SYSNAME NULL :
| |||
unique_constraint_schema |
VARCHAR NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | SQL_IDENTIFIER :
SQL_IDENTIFIER NULL :
| NVARCHAR(128) NULL :
| |||
update_rule |
ENUM NOT NULL :
5.7-8
| VARCHAR NOT NULL :
NULL :
| unsupported | CHARACTER_DATA :
CHARACTER_DATA NULL :
| VARCHAR(11) NULL :
|