21.29.14 The INFORMATION_SCHEMA INNODB_SYS_DATAFILES Table

The INNODB_SYS_DATAFILES table stores InnoDB datafile path information, allowing it to be queried through INFORMATION_SCHEMA.

Table 21.14 INNODB_SYS_DATAFILES Columns

Column nameDescription
SPACEThe tablespace Space ID.
PATHThe tablespace datafile path (for example, .\world\innodb\city.ibd).

Notes: