Difference between revisions of "Delete database"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
[[DROP DATABASE]] [IF EXISTS] [[my_database_name]][[;]] | [[DROP DATABASE]] [IF EXISTS] [[my_database_name]][[;]] | ||
Do not forget the <code>;</code> at the end of the line | Do not forget the <code>;</code> at the end of the line | ||
| + | |||
| + | |||
[[DROP DATABASE]] [IF EXISTS] [[my_database_name]] (FORCE) [[;]] | [[DROP DATABASE]] [IF EXISTS] [[my_database_name]] (FORCE) [[;]] | ||
| + | Note: FORCE introduced in 2022 ([[PostgreSQL 13]]) | ||
DROP DATABASE database_name; | DROP DATABASE database_name; | ||
Latest revision as of 12:28, 16 December 2022
PostgreSQL[edit]
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[edit]
DELETEDROP TABLECREATE DATABASE\list- PostgreSQL superuser
ALTER DATABASEERROR: must be owner of database
See also[edit]
Advertising:
