SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name

Shows the CREATE DATABASE statement that creates the named database. 显示创建命名数据库的CREATE DATABASE语句。If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. 如果SHOW语句包含If NOT EXISTS子句，则输出也包含这样的子句。SHOW CREATE SCHEMA is a synonym for SHOW CREATE DATABASE.SHOW CREATE SCHEMA是SHOW CREATE DATABASE的同义词。

mysql> SHOW CREATE DATABASE test\G
*************************** 1. row ***************************
       Database: test
Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4
                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */

mysql> SHOW CREATE SCHEMA test\G
*************************** 1. row ***************************
       Database: test
Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4
                 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */

SHOW CREATE DATABASE quotes table and column names according to the value of the sql_quote_show_create option. SHOW CREATE DATABASE根据sql_quote_show_create选项的值给表名和列名加引号。See Section 5.1.8, “Server System Variables”.请参阅第5.1.8节，“服务器系统变量”。