Skip to main content
Version: Latest-3.5

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​