All pages
Powered by GitBook
1 of 1

Information Schema CATALOG Table

This table is available as of MariaDB 12.0.

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

It contains the following columns:

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