The INFORMATION_SCHEMA INNODB_DATAFILES Table 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” . 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  INNODB_DATAFILES  table has these columns: • SPACE • PATH The tablespace ID. 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 Notes mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_DATAFILES WHERE SPACE = 57\G *************************** 1. row *************************** SPACE: 57  PATH: ./test/t1.ibd 26.4.11 The INFORMATION_SCHEMA INNODB_FIELDS Table •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. 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 . The name of the original column from the table; the same value as  INNODB_COLUMNS.NAME . • NAME 4859