ContextQMD
Back to Starrocks

SHOW CREATE DATABASE

docs/en/sql-reference/sql-statements/Database/SHOW_CREATE_DATABASE.md

4.1.0756 B
Original Source

SHOW CREATE DATABASE

Shows the SQL command used to create a database.

Syntax

sql
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

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

References