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 the database to drop does not exist, nothing happens.
Dropping a non-empty database triggers an exception. Enabled by default.
Dropping a non-empty database also drops all associated tables and functions.