You are viewing the archived documentation of TiDB, which no longer receives updates.

View latest LTS version docs

SCHEMATA

The SCHEMATA table provides information about databases. The table data is equivalent to the result of the SHOW DATABASES statement.

USE information_schema; desc SCHEMATA;
+----------------------------+--------------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------------------+--------------+------+------+---------+-------+ | CATALOG_NAME | varchar(512) | YES | | NULL | | | SCHEMA_NAME | varchar(64) | YES | | NULL | | | DEFAULT_CHARACTER_SET_NAME | varchar(64) | YES | | NULL | | | DEFAULT_COLLATION_NAME | varchar(32) | YES | | NULL | | | SQL_PATH | varchar(512) | YES | | NULL | | +----------------------------+--------------+------+------+---------+-------+ 5 rows in set (0.00 sec)
SELECT * FROM SCHEMATA;
+--------------+--------------------+----------------------------+------------------------+----------+ | CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH | +--------------+--------------------+----------------------------+------------------------+----------+ | def | INFORMATION_SCHEMA | utf8mb4 | utf8mb4_bin | NULL | | def | METRICS_SCHEMA | utf8mb4 | utf8mb4_bin | NULL | | def | mysql | utf8mb4 | utf8mb4_bin | NULL | | def | PERFORMANCE_SCHEMA | utf8mb4 | utf8mb4_bin | NULL | | def | test | utf8mb4 | utf8mb4_bin | NULL | +--------------+--------------------+----------------------------+------------------------+----------+ 5 rows in set (0.00 sec)

Fields in the SCHEMATA table are described as follows:

  • CATALOG_NAME: The catalog to which the database belongs.
  • SCHEMA_NAME: The database name.
  • DEFAULT_CHARACTER_SET_NAME: The default character set of the database.
  • DEFAULT_COLLATION_NAME: The default collation of the database.
  • SQL_PATH: The value of this item is always NULL.