Information Schema SCHEMATA Table

The Information Schema SCHEMATA table stores information about databases on the server, including default character sets and collations.

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

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}