> 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-create-catalog.md).

# SHOW CREATE CATALOG

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

## Syntax

```bnf
SHOW CREATE CATALOG catalog_name
```

## Description

Shows the [CREATE CATALOG](/docs/server/security/user-account-management/catalogs/create-catalog.md) statement that creates the given [catalog](/docs/server/security/user-account-management/catalogs.md).

## Examples

```sql
SHOW CREATE CATALOG def;
+---------+-------------------------------------------------------------------------------------------------------+
| Catalog | Create Catalog                                                                                        |
+---------+-------------------------------------------------------------------------------------------------------+
| def     | CREATE CATALOG `def` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci COMMENT 'default catalog' |
+---------+-------------------------------------------------------------------------------------------------------+
```

## 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)

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

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