content_image/740057.jpg
## 26.4.10 The INFORMATION_SCHEMA INNODB_DATAFILES Table 

The INNODB_DATAFILES  table provides data file path information for InnoDB  file-per-table and general tablespaces. 

For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . 

<img src='content_image/740057.jpg'>

The INNODB_DATAFILES  table has these columns: 

• SPACE 

The tablespace ID. 

• PATH 

## Note 

The INFORMATION_SCHEMA FILES  table reports metadata for InnoDB  tablespace types including file-per-table tablespaces, general tablespaces, the system tablespace, the global temporary tablespace, and undo tablespaces. 

The tablespace data file path. If a file-per-table tablespace is created in a location outside the MySQL data directory, the path value is a fully qualified directory path. Otherwise, the path is relative to the data directory. 

## Example 

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE SPACE = 57\G *************************** 1. row *************************** SPACE: 57  PATH: ./test/t1.ibd 

## 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.11 The INFORMATION_SCHEMA INNODB_FIELDS Table 

The INNODB_FIELDS  table provides metadata about the key columns (fields) of InnoDB  indexes. 

For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . 

The INNODB_FIELDS  table has these columns: 

• INDEX_ID 

An identifier for the index associated with this key field; the same value as INNODB_INDEXES.INDEX_ID . 

• NAME 

The name of the original column from the table; the same value as INNODB_COLUMNS.NAME . 

