Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The REFERENTIAL_CONSTRAINTS
table provides information about foreign keys.
INFORMATION_SCHEMA Name |
SHOW Name
|
Remarks |
|---|---|---|
| CONSTRAINT_CATALOG | def | |
| CONSTRAINT_SCHEMA | ||
| CONSTRAINT_NAME | ||
| UNIQUE_CONSTRAINT_CATALOG | def | |
| UNIQUE_CONSTRAINT_SCHEMA | ||
| UNIQUE_CONSTRAINT_NAME | ||
| MATCH_OPTION | ||
| UPDATE_RULE | ||
| DELETE_RULE | ||
| TABLE_NAME | ||
| REFERENCED_TABLE_NAME |
Notes:
TABLE_NAME has the same value as TABLE_NAME
in INFORMATION_SCHEMA.TABLE_CONSTRAINTS.
CONSTRAINT_SCHEMA and CONSTRAINT_NAME
identify the foreign key.
UNIQUE_CONSTRAINT_SCHEMA, UNIQUE_CONSTRAINT_NAME,
and REFERENCED_TABLE_NAME identify the referenced key.
The only valid value at this time for MATCH_OPTION is
NONE.
The possible values for UPDATE_RULE or DELETE_RULE are CASCADE, SET
NULL, SET DEFAULT, RESTRICT, NO ACTION.