Spec-Zone .ru
спецификации, руководства, описания, API

20.30.11. The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table

The INNODB_SYS_FOREIGN table provides status information about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data dictionary.

Table 20.11. INNODB_SYS_FOREIGN Columns

Column name Description
ID The name (not a numeric value) of the foreign key index. Preceded by the database name, for example, test/products_fk.
FOR_NAME The name of the child table in this foreign key relationship.
REF_NAME The name of the parent table in this foreign key relationship.
N_COLS The number of columns in the foreign key index.
TYPE A collection of bit flags with information about the foreign key column, ORed together. 1 = ON DELETE CASCADE, 2 = ON UPDATE SET NULL, 4 = ON UPDATE CASCADE, 8 = ON UPDATE SET NULL, 16 = ON DELETE NOACTION, 32 = ON UPDATE NO ACTION.

Notes: