SHOW CREATE DATABASE¶
SHOW CREATE DATABASE shows the
CREATE DATABASEstatement that creates the named database.
Description¶
SHOW CREATE DATABASE shows the CREATE DATABASE statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause.
Syntax¶
> SHOW CREATE DATABASE db_name
Examples¶
drop database if exists demo_1;
create database demo_1;
mysql> show create database demo_1;
+----------+-------------------------------------+
| Database | Create Database |
+----------+-------------------------------------+
| demo_1 | CREATE DATABASE `demo_1` |
+----------+-------------------------------------+
1 row in set (0.00 sec)