SHOW CREATE DATABASE

Syntax

SHOW CREATE {DATABASE | SCHEMA} db_name

Description

Shows the CREATE DATABASE statement that creates the given database. SHOW CREATE SCHEMA is a synonym for SHOW CREATE DATABASE. SHOW CREATE DATABASE quotes database names according to the value of the sql_quote_show_create server system variable.

Examples

SHOW CREATE DATABASE test; +----------+-----------------------------------------------------------------+ | Database | Create Database | +----------+-----------------------------------------------------------------+ | test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+-----------------------------------------------------------------+  SHOW CREATE SCHEMA test; +----------+-----------------------------------------------------------------+ | Database | Create Database | +----------+-----------------------------------------------------------------+ | test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+-----------------------------------------------------------------+

With sql_quote_show_create turned off, the output looks slightly differently:

SHOW CREATE DATABASE test; +----------+---------------------------------------------------------------+ | Database | Create Database | +----------+---------------------------------------------------------------+ | test | CREATE DATABASE test /*!40100 DEFAULT CHARACTER SET latin1 */ | +----------+---------------------------------------------------------------+

Current

< 10.6.5 / 10.5.13 / 10.4.22

In the DEFAULT clause of a SHOW CREATE statement, numbers are quoted.

See Also

• CREATE DATABASE

• ALTER DATABASE

• Character Sets and Collations

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}