Drop Database

DROP (DATABASE|SCHEMA) [IF EXISTS] db_name [(RESTRICT|CASCADE)]

Drop a database and delete the directory associated with the database from the file system. If the database does not exist, an exception is thrown.

IF EXISTS
If the database to drop does not exist, nothing happens.
RESTRICT
Dropping a non-empty database triggers an exception. Enabled by default.
CASCADE
Dropping a non-empty database also drops all associated tables and functions.