information_schema.referential_constraints.match_option

mysql

type: ENUM NOT NULL
5.7-8

mariadb

type: NULL
Note:
Always NONE.
© 2022 MariaDB
5.1-10.8
type: VARCHAR NOT NULL
Note:
Always NONE.
© 2022 MariaDB
10.2-10.7

tidb

postgres

type: CHARACTER_DATA NULL
Note:
Match option of the foreign key constraint: FULL, PARTIAL, or NONE.
© 1996-2022 The PostgreSQL Global Development Group
10-15
type: CHARACTER_DATA
Note:
Match option of the foreign key constraint: FULL, PARTIAL, or NONE.
© 1996-2022 The PostgreSQL Global Development Group
7.4-9.6

cockroachdb

type: unknown
Note:
Match option of the foreign key constraint: FULL, PARTIAL, or NONE.
© 2022 CockroachDB
2-21.2

mssql

type: VARCHAR(7) NULL
Note:
Referential constraint-matching conditions. Always returns SIMPLE. This means that no match is defined. The condition is considered a match when one of the following is true: At least one value in the foreign key column is NULL. All values in the foreign key column are not NULL, and there is a row in the primary key table that has the same key.
© Microsoft 2022
azuresqldb-current-sql-server-ver15