DROP (DATABASE|SCHEMA) [IF EXISTS] db_name [(RESTRICT|CASCADE)]
Drop a database. If the database to drop does not exist, an exception will be thrown. This also deletes the directory associated with the database from the file system.
- If the database to drop does not exist, nothing will happen.
- Dropping a non-empty database will trigger an exception. Enabled by default
- Dropping a non-empty database will also drop all associated tables and functions.