Skip to main content

SHOW CREATE DATABASE

Shows the CREATE DATABASE statement that creates the named database.

Syntax

SHOW CREATE { DATABASE | SCHEMA } database_name

SHOW CREATE SCHEMA is a synonym for SHOW CREATE DATABASE.

Examples

mysql> SHOW CREATE DATABASE default;
+----------+---------------------------+
| Database | Create Database |
+----------+---------------------------+
| default | CREATE DATABASE `default` |
+----------+---------------------------+