information_schema.tables.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
tables |
||||||||
auto_increment |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
avg_row_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
check_time |
DATETIME NULL:
5.7-8
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
checksum |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
commit_action |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
create_options |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(255) NULL:
| unsupported | unsupported | unsupported | ||
create_time |
TIMESTAMP NOT NULL:
8
DATETIME NULL:
5.7
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
data_free |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
data_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
engine |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(64) NULL:
| unsupported | unsupported | unsupported | ||
index_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
is_insertable_into |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO NULL:
| unsupported | unsupported | ||
is_typed |
unsupported | unsupported | unsupported | CHARACTER_DATA:
YES_OR_NO:
YES_OR_NO NULL:
| unsupported | unsupported | ||
max_data_length |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
max_index_length |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
reference_generation |
unsupported | unsupported | unsupported | CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | unsupported | ||
row_format |
ENUM NULL:
5.7-8
| NULL:
| VARCHAR(10) NULL:
| unsupported | unsupported | unsupported | ||
self_referencing_column_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
table_catalog |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_collation |
VARCHAR NULL:
5.7-8
| NULL:
| VARCHAR(32) NOT NULL:
| unsupported | unsupported | unsupported | ||
table_comment |
VARCHAR NOT NULL:
5.7
TEXT NULL:
8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(2048) NULL:
| unsupported | unsupported | unsupported | ||
table_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
table_rows |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
table_schema |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
table_type |
ENUM NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| CHARACTER_DATA NULL:
CHARACTER_DATA:
| VARCHAR(10) NULL:
| |||
temporary |
unsupported | NULL:
| unsupported | unsupported | unsupported | unsupported | ||
tidb_row_id_sharding_info |
unsupported | unsupported | VARCHAR(255) NULL:
| unsupported | unsupported | unsupported | ||
tidb_table_id |
unsupported | unsupported | BIGINT(21) NULL:
| unsupported | unsupported | unsupported | ||
update_time |
DATETIME NULL:
5.7-8
| NULL:
| DATETIME NULL:
| unsupported | unsupported | unsupported | ||
user_defined_type_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_name |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
user_defined_type_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | unsupported | ||
version |
BIGINT NULL:
5.7-8
| NULL:
| BIGINT(21) NULL:
| unsupported | unsupported | |||