SHOW CREATE CATALOG

Reference for the SHOW CREATE CATALOG statement, which displays the SQL statement used to create a specific catalog.

Catalogs are planned for an upcoming release, and don't yet appear in any current releases.

Syntax

SHOW CREATE CATALOG catalog_name

Description

Shows the CREATE CATALOG statement that creates the given catalog.

Examples

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

• Character Sets and Collations

_{This page is licensed: CC BY-SA / Gnu FDL}