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.
NOTICE:
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
Suggestions
drop database
Do not delete databases during transactions.
Feedback