> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-catalog-table.md).

# Information Schema CATALOG Table

{% hint style="info" %}
This table is available as of MariaDB 12.0.
{% endhint %}

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `CATALOG` table stores information about [catalogs](/docs/server/security/user-account-management/catalogs.md) on the server.

It contains the following columns:

| Column                        | Description                                                                                                      |
| ----------------------------- | ---------------------------------------------------------------------------------------------------------------- |
| CATALOG\_NAME                 | Catalog name.                                                                                                    |
| DEFAULT\_CHARACTER\_SET\_NAME | Default [character set](/docs/server/reference/data-types/string-data-types/character-sets.md) for the database. |
| DEFAULT\_COLLATION\_NAME      | Default [collation](/docs/server/reference/data-types/string-data-types/character-sets.md).                      |
| SCHEMA\_COMMENT               | Catalog comment                                                                                                  |

## Example

```sql
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](/docs/server/security/user-account-management/catalogs/show-catalogs.md)
* [SHOW CREATE CATALOG](/docs/server/security/user-account-management/catalogs/show-create-catalog.md)
* [CREATE CATALOG](/docs/server/security/user-account-management/catalogs/create-catalog.md)
* [DROP CATALOG](/docs/server/security/user-account-management/catalogs/drop-catalog.md)
* [Character Sets and Collations](/docs/server/reference/data-types/string-data-types/character-sets/supported-character-sets-and-collations.md)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}