Delete database

From wikieduonline
Revision as of 12:28, 16 December 2022 by Ant (talk | contribs) (→‎PostgreSQL)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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: