Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
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:
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.