information_schema.schemata.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
schemata |
||||||||
catalog_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(512) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | SYSNAME NULL:
| ||
default_character_set_catalog |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(6) NULL:
| ||
default_character_set_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| SYSNAME NULL:
| |||
default_character_set_schema |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | VARCHAR(3) NULL:
| ||
default_collation_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(32) NULL:
| unsupported | unsupported | unsupported | ||
default_encryption |
ENUM NOT NULL:
8
| unsupported | unsupported | unsupported | unsupported | unsupported | ||
schema_comment |
unsupported | VARCHAR NOT NULL:
NULL:
| unsupported | unsupported | unsupported | unsupported | ||
schema_name |
VARCHAR NOT NULL:
5.7-8
| VARCHAR NOT NULL:
NULL:
| VARCHAR(64) NULL:
| SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| NVARCHAR(128) NULL:
| |||
schema_owner |
unsupported | unsupported | unsupported | SQL_IDENTIFIER:
SQL_IDENTIFIER NULL:
| unsupported | NVARCHAR(128) NULL:
| ||
sql_path |
BINARY NULL:
5.7-8
| NULL:
| VARCHAR(512) NULL:
| CHARACTER_DATA:
CHARACTER_DATA NULL:
| unsupported | |||
table_catalog |
unsupported | unsupported | unsupported | unsupported | unsupported | |||
table_schema |
unsupported | unsupported | unsupported | unsupported | unsupported | |||