information_schema.innodb_sys_tables.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_sys_tables |
||||||||
file_format |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
flag |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
n_cols |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
5.7
| ENUM NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NULL:
5.7
| ENUM NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
zip_page_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||