Information Schema SCHEMATA Table

The Information Schema SCHEMATA table stores information about databases on the server.

It contains the following columns:

Column	Description
CATALOG_NAME	Always def.
SCHEMA_NAME	Database name.
DEFAULT_CHARACTER_SET_NAME	Default character set for the database.
DEFAULT_COLLATION_NAME	Default collation.
SQL_PATH	Always NULL.
SCHEMA_COMMENT	Database comment. From MariaDB 10.5.0.

Example

Current

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA\G ... *************************** 2. row ***************************  CATALOG_NAME: def  SCHEMA_NAME: presentations DEFAULT_CHARACTER_SET_NAME: latin1  DEFAULT_COLLATION_NAME: latin1_swedish_ci  SQL_PATH: NULL  SCHEMA_COMMENT: Presentations for conferences ...

< 10.5.0

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA\G *************************** 1. row ***************************  CATALOG_NAME: def  SCHEMA_NAME: information_schema DEFAULT_CHARACTER_SET_NAME: utf8  DEFAULT_COLLATION_NAME: utf8_general_ci  SQL_PATH: NULL *************************** 2. row ***************************  CATALOG_NAME: def  SCHEMA_NAME: mysql DEFAULT_CHARACTER_SET_NAME: latin1  DEFAULT_COLLATION_NAME: latin1_swedish_ci  SQL_PATH: NULL *************************** 3. row ***************************  CATALOG_NAME: def  SCHEMA_NAME: performance_schema DEFAULT_CHARACTER_SET_NAME: utf8  DEFAULT_COLLATION_NAME: utf8_general_ci  SQL_PATH: NULL *************************** 4. row ***************************  CATALOG_NAME: def  SCHEMA_NAME: test DEFAULT_CHARACTER_SET_NAME: latin1  DEFAULT_COLLATION_NAME: latin1_swedish_ci  SQL_PATH: NULL ...

See Also

• CREATE DATABASE

• ALTER DATABASE

• DROP DATABASE

• SHOW CREATE DATABASE

• SHOW DATABASES

• Character Sets and Collations

_{This page is licensed: CC BY-SA / Gnu FDL}