information_schema.files.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
files |
||||||||
autoextend_size |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
avg_row_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
check_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
checksum |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
create_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
creation_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_free |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
data_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
deleted_rows |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
engine |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
extent_size |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
extra |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_id |
BIGINT NOT NULL:
5.7
BIGINT NULL:
8
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_name |
TEXT NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_type |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
free_extents |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fulltext_keys |
BINARY NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
index_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
initial_size |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
last_access_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
last_update_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
logfile_group_name |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
logfile_group_number |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
max_data_length |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
maximum_size |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
recover_time |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
status |
VARCHAR NOT NULL:
5.7
VARCHAR NULL:
8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_catalog |
CHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_name |
BINARY NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_rows |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_schema |
BINARY NULL:
5.7-8
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
tablespace_name |
VARCHAR NOT NULL:
8
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
total_extents |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
transaction_counter |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
update_count |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
update_time |
BINARY NULL:
5.7-8
| DATETIME NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
version |
BIGINT NULL:
5.7-8
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||