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

20.30.12. The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table

The INNODB_SYS_FOREIGN_COLS table provides status information about the columns of InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN_COLS table in the InnoDB data dictionary.

Table 20.12. INNODB_SYS_FOREIGN_COLS Columns

Column name Description
ID The foreign key index associated with this index key field, using the same value as INNODB_SYS_FOREIGN.ID.
FOR_COL_NAME The name of the associated column in the child table.
REF_COL_NAME The name of the associated column in the parent table.
POS The ordinal position of this key field within the foreign key index,starting from 0.

Notes: