Rechercher dans le manuel MySQL
25.21 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
The REFERENTIAL_CONSTRAINTS
table
provides information about foreign keys.
The REFERENTIAL_CONSTRAINTS
table has
these columns:
CONSTRAINT_CATALOG
The name of the catalog to which the constraint belongs. This value is always
def
.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 always
def
.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.
MATCH_OPTION
The value of the constraint
MATCH
attribute. The only valid value at this time isNONE
.UPDATE_RULE
The value of the constraint
ON UPDATE
attribute. The possible values areCASCADE
,SET NULL
,SET DEFAULT
,RESTRICT
,NO ACTION
.DELETE_RULE
The value of the constraint
ON DELETE
attribute. 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 the
TABLE_CONSTRAINTS
table.REFERENCED_TABLE_NAME
The name of the table referenced by the constraint.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-referential-constraints-table.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.