mysql show create db
snippet in sql

mysql show create db

user8580

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

If the SHOW statement includes an IF NOT EXISTS clause, the output 
too includes such a clause. SHOW CREATE SCHEMA is a synonym for
SHOW CREATE DATABASE.