> 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/security/user-account-management/catalogs/show-catalogs.md).

# SHOW CATALOGS

{% hint style="info" %}
Catalogs are planned for an upcoming release, and don't yet appear in any current releases.
{% endhint %}

## Syntax

```bnf
SHOW CATALOGS
    [LIKE 'pattern' | WHERE expr]
```

## Description

`SHOW CATALOGS` lists the [catalogs](/docs/server/security/user-account-management/catalogs.md) on the MariaDB server host.\
The `LIKE` clause, if present on its own, indicates which catalog names to match. The `WHERE` and `LIKE` clauses can be given to select rows using more general conditions, as discussed in [Extended SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md).

You see only use `SHOW CATALOGS` have the [CATALOG privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md). Only users of the 'def' schema can have this privilege.

If the server was started with the [--skip-show-database](/docs/server/server-management/variables-and-modes/server-system-variables.md#skip_show_database) option, you cannot use this statement unless you have the [SHOW DATABASES privilege](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#show-databases).

The list of results returned by `SHOW CATALOGS` is based on directories in the data directory, which is how MariaDB implements catalogs. It only list directories that have a `mysql` directory.

The [Information Schema Catalogs table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-catalog-table.md) also contains catalog information.

## Examples

```
+---------+--------------------+
| Catalog | Comment            |
+---------+--------------------+
| c1      | This is catalog c1 |
| cat2    |                    |
| def     | default catalog    |
+---------+--------------------+
```

```sql
SHOW CATALOGS LIKE 'c%';
+--------------+--------------------+
| Catalog (c%) | Comment            |
+--------------+--------------------+
| c1           | This is catalog c1 |
| cat2         |                    |
+--------------+--------------------+
```

## See Also

* [CREATE CATALOG](/docs/server/security/user-account-management/catalogs/create-catalog.md)
* [Character Sets and Collations](/docs/server/reference/data-types/string-data-types/character-sets/supported-character-sets-and-collations.md)
* [Information Schema CATALOG Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-catalog-table.md)

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

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