SHOW CREATE DATABASE

Shows the SQL command used to create a database.

Syntax

SHOW CREATE DATABASE <db_name>

Parameters

db_name: the database name, required.

Returns

• Database: the database name

• Create Database: the SQL command used to create the database

Examples

mysql > show create database zj_test;
+----------+---------------------------+
| Database | Create Database           |
+----------+---------------------------+
| zj_test  | CREATE DATABASE `zj_test` |
+----------+---------------------------+

References

• CREATE DATABASE
• SHOW DATABASES
• USE
• DESC
• DROP DATABASE