INNODB_SYS_FOREIGN_COLS table provides
status information about the columns of
foreign keys, equivalent to the information from the
SYS_FOREIGN_COLS table in the
InnoDB data dictionary.
|The foreign key index associated with this index key field, using the
same value as |
|The name of the associated column in the child table.|
|The name of the associated column in the parent table.|
|The ordinal position of this key field within the foreign key index, starting from 0.|
INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding
system table for any new monitoring application you develop.
You must have the
PROCESS privilege to
query this table.