Drop Database

Important

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 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.