files

The files view provides information about the files that store tablespace data. This view is read-only. All users have the read permission on this view.

**Table 1** information_schema.files columns
Name	Type	Description
FILE_ID	bigint	Identifier of the file. This column is not supported in the current version, and it is null.
FILE_NAME	varchar(4000)	Name of the file. This column is not supported in the current version, and it is null.
FILE_TYPE	varchar(20)	Type of the file. This column is not supported in the current version, and it is null.
TABLESPACE_NAME	varchar(64)	Name of the tablespace associated with the file. This column is not supported in the current version, and it is null.
TABLE_CATALOG	varchar(64)	This column is not supported in the current version, and it is null.
TABLE_SCHEMA	varchar(64)	This column is not supported in the current version, and it is null.
TABLE_NAME	varchar(64)	This column is not supported in the current version, and it is null.
LOGFILE_GROUP_NAME	varchar(64)	This column is not supported in the current version, and it is null.
LOGFILE_GROUP_NUMBER	bigint	This column is not supported in the current version, and it is null.
ENGINE	varchar(64)	Storage engine. This column is not supported in the current version, and it is null.
FULLTEXT_KEYS	varchar(64)	This column is not supported in the current version, and it is null.
DELETED_ROWS	bigint	This column is not supported in the current version, and it is null.
UPDATE_COUNT	bigint	This column is not supported in the current version, and it is null.
FREE_EXTENTS	bigint	This column is not supported in the current version, and it is null.
TOTAL_EXTENTS	bigint	This column is not supported in the current version, and it is null.
EXTENT_SIZE	bigint	This column is not supported in the current version, and it is null.
INITIAL_SIZE	bigint unsigned	This column is not supported in the current version, and it is null.
MAXIMUM_SIZE	bigint unsigned	This column is not supported in the current version, and it is null.
AUTOEXTEND_SIZE	bigint unsigned	This column is not supported in the current version, and it is null.
CREATION_TIME	datetime	This column is not supported in the current version, and it is null.
LAST_UPDATE_TIME	datetime	This column is not supported in the current version, and it is null.
LAST_ACCESS_TIME	datetime	This column is not supported in the current version, and it is null.
RECOVER_TIME	bigint	This column is not supported in the current version, and it is null.
TRANSACTION_COUNTER	bigint	This column is not supported in the current version, and it is null.
VERSION	bigint unsigned	This column is not supported in the current version, and it is null.
ROW_FORMAT	varchar(10)	This column is not supported in the current version, and it is null.
TABLE_ROWS	bigint unsigned	This column is not supported in the current version, and it is null.
AVG_ROW_LENGTH	bigint unsigned	This column is not supported in the current version, and it is null.
DATA_LENGTH	bigint unsigned	This column is not supported in the current version, and it is null.
MAX_DATA_LENGTH	bigint unsigned	This column is not supported in the current version, and it is null.
INDEX_LENGTH	bigint unsigned	This column is not supported in the current version, and it is null.
DATA_FREE	bigint unsigned	This column is not supported in the current version, and it is null.
CREATE_TIME	datetime	This column is not supported in the current version, and it is null.
UPDATE_TIME	datetime	This column is not supported in the current version, and it is null.
CHECK_TIME	datetime	This column is not supported in the current version, and it is null.
CHECKSUM	bigint unsigned	This column is not supported in the current version, and it is null.
STATUS	varchar(20)	This column is not supported in the current version, and it is null.
EXTRA	varchar(255)	This column is not supported in the current version, and it is null.