Useful for scripting to drop all tables and deletes the database:
mysqladmin -u[username] -p[password] drop [database] Use with extreme caution.
To DROP database as a SQL Script (you will need DROP privilege on that database):
DROP DATABASE database_name or
DROP SCHEMA database_name