DROP DATABASE

Function

DROP DATABASE deletes a database.

Precautions

• Only the owner of a database or a system administrator has the DROP DATABASE permission.
• The preinstalled POSTGRES, TEMPLATE0, and TEMPLATE1 databases are protected and therefore cannot be deleted. To check databases in the current service, run the gsql statement \l.
• If any users are connected to the database, the database cannot be deleted.
• DROP DATABASE cannot be executed within a transaction block.
• If DROP DATABASE fails and is rolled back, run DROP DATABASE IF EXISTS again.

DROP DATABASE cannot be undone.

Syntax

DROP DATABASE [ IF EXISTS ] database_name ;

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified database does not exist.

• database_name

  Specifies the name of the database to be deleted.

  Value range: an existing database name

Examples

See Examples in CREATE DATABASE.

Helpful Links

CREATE DATABASE

Suggestions

• drop database

  Do not delete databases during transactions.