Information Schema CATALOG Table

MariaDB starting with 12.0

Catalog support is planned for 12.0.

The Information Schema CATALOG table stores information about catalogs on the server.

It contains the following columns:

Column	Description
Column	Description
CATALOG_NAME	Catalog name.
DEFAULT_CHARACTER_SET_NAME	Default character set for the database.
DEFAULT_COLLATION_NAME	Default collation.
SCHEMA_COMMENT	Catalog comment

Example

MariaDB [def.test]> SELECT * FROM INFORMATION_SCHEMA.CATALOGS\G
*************************** 1. row ***************************
              CATALOG_NAME: c1
DEFAULT_CHARACTER_SET_NAME: latin1
    DEFAULT_COLLATION_NAME: latin1_swedish_ci
           CATALOG_COMMENT: This is catalog c1
*************************** 2. row ***************************
              CATALOG_NAME: cat2
DEFAULT_CHARACTER_SET_NAME: latin1
    DEFAULT_COLLATION_NAME: latin1_swedish_ci
           CATALOG_COMMENT: 
*************************** 3. row ***************************
              CATALOG_NAME: def
DEFAULT_CHARACTER_SET_NAME: latin1
    DEFAULT_COLLATION_NAME: latin1_swedish_ci
           CATALOG_COMMENT: default catalog
...

See Also

• SHOW CATALOGS

• SHOW CREATE CATALOG

• CREATE CATALOG

• DROP CATALOG

• Character Sets and Collations

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