Information Schema INNODB_SYS_FOREIGN_COLS Table

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.

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ Information Schema InnoDB Tables ↑
Information Schema INNODB_BUFFER_PAGE Table
Information Schema INNODB_BUFFER_PAGE_LRU Table
Information Schema INNODB_BUFFER_POOL_PAGES Table
Information Schema INNODB_BUFFER_POOL_PAGES_BLOB Table
Information Schema INNODB_BUFFER_POOL_PAGES_INDEX Table
Information Schema INNODB_BUFFER_POOL_STATS Table
Information Schema INNODB_CHANGED_PAGES Table
Information Schema INNODB_CMP and INNODB_CMP_RESET Tables
Information Schema INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
Information Schema INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET Tables
Information Schema INNODB_FT_BEING_DELETED Table
Information Schema INNODB_FT_CONFIG Table
Information Schema INNODB_FT_DEFAULT_STOPWORD Table
Information Schema INNODB_FT_DELETED Table
Information Schema INNODB_FT_INDEX_CACHE Table
Information Schema INNODB_FT_INDEX_TABLE Table
Information Schema INNODB_LOCK_WAITS Table
Information Schema INNODB_LOCKS Table
Information Schema INNODB_METRICS Table
Information Schema INNODB_MUTEXES Table
Information Schema INNODB_SYS_COLUMNS Table
Information Schema INNODB_SYS_DATAFILES Table
Information Schema INNODB_SYS_FIELDS Table
Information Schema INNODB_SYS_FOREIGN Table
Information Schema INNODB_SYS_FOREIGN_COLS Table
Information Schema INNODB_SYS_INDEXES Table
Information Schema INNODB_SYS_SEMAPHORE_WAITS Table
Information Schema INNODB_SYS_TABLES Table
Information Schema INNODB_SYS_TABLESPACES Table
Information Schema INNODB_SYS_TABLESTATS Table
Information Schema INNODB_SYS_VIRTUAL Table
Information Schema INNODB_TABLESPACES_ENCRYPTION Table
Information Schema INNODB_TABLESPACES_SCRUBBING Table
Information Schema INNODB_TRX Table
Information Schema TEMP_TABLES_INFO Table

Information Schema INNODB_SYS_FOREIGN_COLS Table

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB