Skip to main content
Version: Latest-3.3

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