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.