MySQL :: MySQL Information Schema :: 4.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table

10bet网址

version 8.0

5.7
5.6

MySQL Information Schema/INFORMATION_SCHEMA通用表/ The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table

4.25 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table

TheREFERENTIAL_CONSTRAINTStable provides information about foreign keys.

TheREFERENTIAL_CONSTRAINTStable has these columns:

CONSTRAINT_CATALOG
The name of the catalog to which the constraint belongs. This value is alwaysdef.
CONSTRAINT_SCHEMA
The name of the schema (database) to which the constraint belongs.
CONSTRAINT_NAME
The name of the constraint.
UNIQUE_CONSTRAINT_CATALOG
The name of the catalog containing the unique constraint that the constraint references. This value is alwaysdef.
UNIQUE_CONSTRAINT_SCHEMA
The name of the schema containing the unique constraint that the constraint references.
UNIQUE_CONSTRAINT_NAME
The name of the unique constraint that the constraint references.
匹配_OPTION
The value of the constraint匹配attribute. The only valid value at this time isNONE.
UPDATE_RULE
The value of the constraintON UPDATEattribute. The possible values areCASCADE,SET NULL,SET DEFAULT,RESTRICT,NO ACTION.
DELETE_RULE
The value of the constraintON DELETEattribute. The possible values areCASCADE,SET NULL,SET DEFAULT,RESTRICT,NO ACTION.
TABLE_NAME
The name of the table. This value is the same as in theTABLE_CONSTRAINTStable.
REFERENCED_TABLE_NAME
The name of the table referenced by the constraint.

PREV 首页 UP NEXT