DROP DATABASE

Description

Drops a database.

Precautions

• Only the database owner or a user granted the DROP permission can run the DROP DATABASE command. System administrators have 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. To check the current database connections, open the DV_SESSIONS view.
• DROP DATABASE cannot be executed within a transaction block.
• Before deleting a database, run the CLEAN CONNECTION TO ALL FORCE FOR DATABASE XXXX command to forcibly stop the existing user connections and backend threads, preventing database deletion failures caused by running backend threads. Forcibly stopping backend threads may cause data inconsistency in the current database. Therefore, execute this command only when you are sure to drop the database.
• If DROP DATABASE fails and is rolled back, run DROP DATABASE IF EXISTS again.

DROP DATABASE cannot be undone.

Syntax

1

DROP DATABASE [ IF EXISTS ] database_name ;

Parameters

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