This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See DROP SCHEMA.
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.