## Notes 

REF_NAME: test/parent N_COLS: 1 TYPE: 1 

•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. 

## 26.4.13 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: 

• ID 

The foreign key index associated with this index key field; the same value as INNODB_FOREIGN.ID . 

## Example 

• 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. 

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 

## 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. 

## 26.4.14 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table 

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 

