The Information Schema CATALOG
table stores information about catalogs on the server.
It contains the following columns:
CATALOG_NAME
Catalog name.
DEFAULT_CHARACTER_SET_NAME
Default character set for the database.
DEFAULT_COLLATION_NAME
Default collation.
SCHEMA_COMMENT
Catalog comment
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
...
This page is licensed: CC BY-SA / Gnu FDL