The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table The  INNODB_FOREIGN_COLS  table provides status information about  InnoDB  foreign key columns. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . The  INNODB_FOREIGN_COLS  table has these columns: The foreign key index associated with this index key field; the same value as  INNODB_FOREIGN.ID . The name of the associated column in the child table. The name of the associated column in the parent table. The ordinal position of this key field within the foreign key index, starting from 0. The  INNODB_FT_BEING_DELETED  table provides a snapshot of the  INNODB_FT_DELETED  table; it is used only during an  OPTIMIZE TABLE  maintenance operation. When  OPTIMIZE TABLE  is run, the  INNODB_FT_BEING_DELETED  table is emptied, and  DOC_ID  values are removed from the INNODB_FT_DELETED  table. Because the contents of  INNODB_FT_BEING_DELETED  typically have 26.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table Notes Example 26.4.13 The INFORMATION_SCHEMA INNODB_FOREIGN_COLS Table Notes •You must have the  PROCESS  privilege to query this table. •Use the  INFORMATION_SCHEMA COLUMNS  table or the  SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. • ID • FOR_COL_NAME • REF_COL_NAME • POS •You must have the  PROCESS  privilege to query this table. •Use the  INFORMATION_SCHEMA COLUMNS  table or the  SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. 4861 mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS WHERE ID = ’test/fk1’\G *************************** 1. row *************************** ID: test/fk1 FOR_COL_NAME: parent_id REF_COL_NAME: id POS: 0 REF_NAME: test/parent N_COLS: 1 TYPE: 1