The Information Schema INNODB_SYS_FOREIGN_COLS table contains information about InnoDB foreign key columns.
The PROCESS privilege is required to view the table.
It has the following columns:
| Column | Description |
|---|---|
ID |
Foreign key index associated with this column, matching the INNODB_SYS_FOREIGN.ID field. |
FOR_COL_NAME |
Child column name. |
REF_COL_NAME |
Parent column name. |
POS |
Ordinal position of the column in the table, starting from 0. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-innodb_sys_foreign_cols-table/