SCHEMATA

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

  1. USE information_schema;
  2. desc SCHEMATA;
  1. +----------------------------+--------------+------+------+---------+-------+
  2. | Field                      | Type         | Null | Key  | Default | Extra |
  3. +----------------------------+--------------+------+------+---------+-------+
  4. | CATALOG_NAME               | varchar(512) | YES  |      | NULL    |       |
  5. | SCHEMA_NAME                | varchar(64)  | YES  |      | NULL    |       |
  6. | DEFAULT_CHARACTER_SET_NAME | varchar(64)  | YES  |      | NULL    |       |
  7. | DEFAULT_COLLATION_NAME     | varchar(32)  | YES  |      | NULL    |       |
  8. | SQL_PATH                   | varchar(512) | YES  |      | NULL    |       |
  9. +----------------------------+--------------+------+------+---------+-------+
  10. 5 rows in set (0.00 sec)
  1. SELECT * FROM SCHEMATA;
  1. +--------------+--------------------+----------------------------+------------------------+----------+
  2. | CATALOG_NAME | SCHEMA_NAME        | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
  3. +--------------+--------------------+----------------------------+------------------------+----------+
  4. | def          | INFORMATION_SCHEMA | utf8mb4                    | utf8mb4_bin            | NULL     |
  5. | def          | METRICS_SCHEMA     | utf8mb4                    | utf8mb4_bin            | NULL     |
  6. | def          | mysql              | utf8mb4                    | utf8mb4_bin            | NULL     |
  7. | def          | PERFORMANCE_SCHEMA | utf8mb4                    | utf8mb4_bin            | NULL     |
  8. | def          | test               | utf8mb4                    | utf8mb4_bin            | NULL     |
  9. +--------------+--------------------+----------------------------+------------------------+----------+
  10. 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.