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

Shows the  statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause.  is a synonym for .

mysql> SHOW CREATE DATABASE test\G *************************** 1. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 */ mysql> SHOW CREATE SCHEMA test\G *************************** 1. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 */

 quotes table and column names according to the value of the  option. See .