files

The files view provides information about the files that store tablespace data. For details, see Table 1. 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 a file. This column is not supported in the current version, and the value is null.
FILE_NAME	varchar(4000)	Name of the file. This column is not supported in the current version, and the value is null.
FILE_TYPE	varchar(20)	Type of the file. This column is not supported in the current version, and the value is null.
TABLESPACE_NAME	varchar(64)	Name of the tablespace associated with the file. This column is not supported in the current version, and the value is null.
TABLE_CATALOG	varchar(64)	This column is not supported in the current version, and the value is null.
TABLE_SCHEMA	varchar(64)	This column is not supported in the current version, and the value is null.
TABLE_NAME	varchar(64)	This column is not supported in the current version, and the value is null.
LOGFILE_GROUP_NAME	varchar(64)	This column is not supported in the current version, and the value is null.
LOGFILE_GROUP_NUMBER	bigint	This column is not supported in the current version, and the value is null.
ENGINE	varchar(64)	Storage engine. This column is not supported in the current version, and the value is null.
FULLTEXT_KEYS	varchar(64)	This column is not supported in the current version, and the value is null.
DELETED_ROWS	bigint	This column is not supported in the current version, and the value is null.
UPDATE_COUNT	bigint	This column is not supported in the current version, and the value is null.
FREE_EXTENTS	bigint	This column is not supported in the current version, and the value is null.
TOTAL_EXTENTS	bigint	This column is not supported in the current version, and the value is null.
EXTENT_SIZE	bigint	This column is not supported in the current version, and the value is null.
INITIAL_SIZE	bigint unsigned	This column is not supported in the current version, and the value is null.
MAXIMUM_SIZE	bigint unsigned	This column is not supported in the current version, and the value is null.
AUTOEXTEND_SIZE	bigint unsigned	This column is not supported in the current version, and the value is null.
CREATION_TIME	datetime	This column is not supported in the current version, and the value is null.
LAST_UPDATE_TIME	datetime	This column is not supported in the current version, and the value is null.
LAST_ACCESS_TIME	datetime	This column is not supported in the current version, and the value is null.
RECOVER_TIME	bigint	This column is not supported in the current version, and the value is null.
TRANSACTION_COUNTER	bigint	This column is not supported in the current version, and the value is null.
VERSION	bigint unsigned	This column is not supported in the current version, and the value is null.
ROW_FORMAT	varchar(10)	This column is not supported in the current version, and the value is null.
TABLE_ROWS	bigint unsigned	This column is not supported in the current version, and the value is null.
AVG_ROW_LENGTH	bigint unsigned	This column is not supported in the current version, and the value is null.
DATA_LENGTH	bigint unsigned	This column is not supported in the current version, and the value is null.
MAX_DATA_LENGTH	bigint unsigned	This column is not supported in the current version, and the value is null.
INDEX_LENGTH	bigint unsigned	This column is not supported in the current version, and the value is null.
DATA_FREE	bigint unsigned	This column is not supported in the current version, and the value is null.
CREATE_TIME	datetime	This column is not supported in the current version, and the value is null.
UPDATE_TIME	datetime	This column is not supported in the current version, and the value is null.
CHECK_TIME	datetime	This column is not supported in the current version, and the value is null.
CHECKSUM	bigint unsigned	This column is not supported in the current version, and the value is null.
STATUS	varchar(20)	This column is not supported in the current version, and the value is null.
EXTRA	varchar(255)	This column is not supported in the current version, and the value is null.