19.30.11. 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 19.11. 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:
Since the INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding InnoDB
system table for any new monitoring application you develop.
You must have the PROCESS privilege to
query this table.
© 2012, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.