Updated on 2023-10-23 GMT+08:00

DROP DATABASE

Function

DROP DATABASE deletes a database.

Precautions

  • Only the database owner or a user granted with the DROP permission can run the DROP DATABASE command. The system administrator has this permission by default.
  • 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.