INNODB_SYS_FOREIGN table provides status
foreign keys, equivalent
to the information from the
InnoDB data dictionary.
|The name (not a numeric value) of the foreign key index. Preceded by the
database name, for example,
|The name of the child table in this foreign key relationship.|
|The name of the parent table in this foreign key relationship.|
|The number of columns in the foreign key index.|
|A collection of bit flags with information about the foreign key column,
ORed together. 1 = |
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.