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` |
+----------+---------------------------+