Syntax:
SHOW CREATE {DATABASE | SCHEMA} db_name

Shows the CREATE DATABASE statement that creates the given database.
SHOW CREATE SCHEMA is a synonym for SHOW CREATE DATABASE as of MySQL
5.0.2.

URL: http://dev.mysql.com/doc/refman/5.0/en/show-create-database.html

