SHOW CREATE DATABASE

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

The SHOW CREATE DATABASE statement returns the CREATE DATABASE statement that would recreate the specified database. If the SHOW statement includes the IF NOT EXISTS clause, that clause is also included in the output.

For more information, see the MySQL documentation: SHOW CREATE DATABASE Statement.