Delete database

From wikieduonline
(Redirected from DROP DATABASE)
Jump to navigation Jump to search

PostgreSQL

DROP DATABASE [IF EXISTS] my_database_name;

Do not forget the ; at the end of the line


DROP DATABASE [IF EXISTS] my_database_name (FORCE) ;
Note: FORCE introduced in 2022 (PostgreSQL 13)
DROP DATABASE database_name;
Output:
DROP DATABASE
DROP DATABASE database_name (FORCE);


ERROR: database "XXXXX" is being accessed by other users
DETAIL: There are 4 other sessions using the database

Related terms:

Related

See also

Advertising: