{"Entry":{"collection":"sql","key":"drop-database","name":"DROP DATABASE","aliases":["dropdatabase"],"metadata":{"aliases":["dropdatabase"],"changed_in":["8.2","13"],"changes":[{"from":"6.5","purpose_changed":true,"renamed":null,"sections":{"added":[],"changed":["description","compatibility"],"removed":[]},"status":"changed","synopsis":null,"to":"7.0"},{"from":"7.0","purpose_changed":false,"renamed":{"from_file":"sql-dropdatabase.htm","to_file":"sql-dropdatabase.html"},"sections":{"added":[],"changed":[],"removed":[]},"status":"changed","synopsis":null,"to":"7.1"},{"from":"7.1","purpose_changed":true,"renamed":null,"sections":{"added":[],"changed":["description","compatibility"],"removed":[]},"status":"changed","synopsis":null,"to":"7.2"},{"from":"7.3","purpose_changed":false,"renamed":null,"sections":{"added":["parameters","notes","see_also"],"changed":["description","compatibility"],"removed":[]},"status":"changed","synopsis":null,"to":"7.4"},{"from":"8.0","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"8.1"},{"from":"8.1","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters","compatibility"],"removed":[]},"status":"changed","synopsis":{"added":["DROP DATABASE [ IF EXISTS ] name"],"removed":[]},"to":"8.2"},{"from":"12","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description","parameters"],"removed":[]},"status":"changed","synopsis":{"added":["DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]","FORCE"],"removed":[]},"to":"13"},{"from":"16","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":null,"to":"17"},{"from":"18","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":null,"to":"19"}],"content_hash":"97347fa3e333aa5fda80e96cff2de2935c70265ae0c9258018450a1c7d791e64","editorial":{},"first_version":"6.4","group":"schema","imported_at":"2026-09-30T17:43:37.792031+08:00","last_version":"20","name":"DROP DATABASE","object":"DATABASE","position":4002,"present_in":["6.4","6.5","7.0","7.1","7.2","7.3","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6","10","11","12","13","14","15","16","17","18","19","20"],"purpose":"remove a database","purpose_zh":"","related":["create-database"],"slug":"drop-database","source_rev":"a709ab85","synopsis":"DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]\n\nwhere option can be:\n\nFORCE","verb":"DROP"}},"Definition":{"Collection":"sql","Key":"drop-database","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"drop-database","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-DROPDATABASE","file":"sql-dropdatabase.html","lang":"en","name":"DROP DATABASE","purpose":"remove a database","purpose_zh":"","related":["create-database"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. It cannot be executed while you are connected to the target database. (Connect to \u003ccode class=\"literal\"\u003epostgres\u003c/code\u003e or any other database to issue this command.) Also, if anyone else is connected to the target database, this command will fail unless you use the \u003ccode class=\"literal\"\u003eFORCE\u003c/code\u003e option described below.\u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e cannot be undone. Use it with care!\u003c/p\u003e","key":"description","title":"Description"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eIF EXISTS\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eDo not throw an error if the database does not exist. A notice is issued in this case.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eThe name of the database to remove.\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eFORCE\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003eAttempt to terminate all existing connections to the target database. It doesn't terminate if prepared transactions, active logical replication slots or subscriptions are present in the target database.\u003c/p\u003e\u003cp\u003eThis terminates background worker connections and connections that the current user has permission to terminate with \u003ccode class=\"function\"\u003epg_terminate_backend\u003c/code\u003e, described in \u003ca href=\"/docs/18/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL\" title=\"9.28.2. Server Signaling Functions\"\u003eSection 9.28.2\u003c/a\u003e. If connections would remain, this command will fail.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e cannot be executed inside a transaction block.\u003c/p\u003e\u003cp\u003eThis command cannot be executed while connected to the target database. Thus, it might be more convenient to use the program \u003ca href=\"/docs/18/app-dropdb.html\" title=\"dropdb\"\u003e\u003cspan class=\"refentrytitle\"\u003e\u003cspan class=\"application\"\u003edropdb\u003c/span\u003e\u003c/span\u003e\u003c/a\u003e instead, which is a wrapper around this command.\u003c/p\u003e","key":"notes","title":"Notes"},{"html":"\u003cp\u003eThere is no \u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e statement in the SQL standard.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-database/?v=18\" title=\"CREATE DATABASE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE DATABASE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"DROP DATABASE [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ [ WITH ] ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e [, ...] ) ]\n\n\u003cspan class=\"phrase\"\u003ewhere \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e can be:\u003c/span\u003e\n\n    FORCE","synopsis_text":"DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]\n\nwhere option can be:\n\nFORCE"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"drop-database","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"DROP DATABASE","Summary":"移除一个数据库","BodyHTML":"\u003cpre\u003eDROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]\n\n其中 option 可以是：\n\nFORCE\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eDROP DATABASE\u003c/code\u003e删除一个数据库。它会移除该数据库的系统目录条目，并删除包含数据的目录。只有数据库拥有者才能执行此命令。连接到目标数据库时不能执行此命令。（请连接到\u003ccode\u003epostgres\u003c/code\u003e或任何其他数据库来发出此命令。）另外，如果还有其他人连接到目标数据库，除非使用下面描述的 \u003ccode\u003eFORCE\u003c/code\u003e选项，否则该命令将失败。\u003c/p\u003e\u003cp\u003e\u003ccode\u003eDROP DATABASE\u003c/code\u003e无法撤销。请谨慎使用！\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e参数\u003c/h2\u003e\u003cdiv\u003e\u003cdl\u003e\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eIF EXISTS\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e如果该数据库不存在，则不要抛出错误。这种情况下会发出一个提示。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003cem\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e要移除的数据库名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eFORCE\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e尝试终止所有现有的、连接到目标数据库的连接。如果目标数据库中存在预备事务、活动的逻辑复制槽或订阅，则不会终止这些连接。\u003c/p\u003e\u003cp\u003e这会终止后台工作进程连接，以及当前用户有权使用 \u003ccode\u003epg_terminate_backend\u003c/code\u003e终止的连接，该函数见\u003ca href=\"/docs/18/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL\" rel=\"nofollow\"\u003e第 9.28.2 节\u003c/a\u003e。如果仍有连接保留，该命令将失败。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e注解\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eDROP DATABASE\u003c/code\u003e不能在事务块内执行。\u003c/p\u003e\u003cp\u003e由于该命令不能在连接到目标数据库时执行，因此改用程序\u003ca href=\"/docs/18/app-dropdb.html\" title=\"dropdb\" rel=\"nofollow\"\u003e\u003cspan\u003e\u003cspan\u003edropdb\u003c/span\u003e\u003c/span\u003e\u003c/a\u003e可能更方便，它是此命令的一个包装器。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003eSQL 标准中没有\u003ccode\u003eDROP DATABASE\u003c/code\u003e语句。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/create-database/?v=18\" title=\"CREATE DATABASE\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE DATABASE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"5a4c4055f31f7100b306ddfbc3557b9703bee03b07697d9bb41c18899bc92587","Payload":{"purpose_zh":"移除一个数据库","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e删除一个数据库。它会移除该数据库的系统目录条目，并删除包含数据的目录。只有数据库拥有者才能执行此命令。连接到目标数据库时不能执行此命令。（请连接到\u003ccode class=\"literal\"\u003epostgres\u003c/code\u003e或任何其他数据库来发出此命令。）另外，如果还有其他人连接到目标数据库，除非使用下面描述的 \u003ccode class=\"literal\"\u003eFORCE\u003c/code\u003e选项，否则该命令将失败。\u003c/p\u003e\u003cp\u003e\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e无法撤销。请谨慎使用！\u003c/p\u003e","key":"description","title":"描述"},{"html":"\u003cdiv class=\"variablelist\"\u003e\u003cdl class=\"variablelist\"\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eIF EXISTS\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e如果该数据库不存在，则不要抛出错误。这种情况下会发出一个提示。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e要移除的数据库名称。\u003c/p\u003e\u003c/dd\u003e\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eFORCE\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\u003cdd\u003e\u003cp\u003e尝试终止所有现有的、连接到目标数据库的连接。如果目标数据库中存在预备事务、活动的逻辑复制槽或订阅，则不会终止这些连接。\u003c/p\u003e\u003cp\u003e这会终止后台工作进程连接，以及当前用户有权使用 \u003ccode class=\"function\"\u003epg_terminate_backend\u003c/code\u003e终止的连接，该函数见\u003ca href=\"/docs/18/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL\" title=\"9.28.2. 服务器信号函数\"\u003e第 9.28.2 节\u003c/a\u003e。如果仍有连接保留，该命令将失败。\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e不能在事务块内执行。\u003c/p\u003e\u003cp\u003e由于该命令不能在连接到目标数据库时执行，因此改用程序\u003ca href=\"/docs/18/app-dropdb.html\" title=\"dropdb\"\u003e\u003cspan class=\"refentrytitle\"\u003e\u003cspan class=\"application\"\u003edropdb\u003c/span\u003e\u003c/span\u003e\u003c/a\u003e可能更方便，它是此命令的一个包装器。\u003c/p\u003e","key":"notes","title":"注解"},{"html":"\u003cp\u003eSQL 标准中没有\u003ccode class=\"command\"\u003eDROP DATABASE\u003c/code\u003e语句。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-database/?v=18\" title=\"CREATE DATABASE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE DATABASE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"DROP DATABASE [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e [ [ WITH ] ( \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e [, ...] ) ]\n\n\u003cspan class=\"phrase\"\u003e其中 \u003cem class=\"replaceable\"\u003e\u003ccode\u003eoption\u003c/code\u003e\u003c/em\u003e 可以是：\u003c/span\u003e\n\n    FORCE","synopsis_text":"DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ]\n\n其中 option 可以是：\n\nFORCE"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","6.4","6.5","7.0","7.1","7.2","7.3","7.4","8.0","8.1","8.2","8.3","8.4","9.0","9.1","9.2","9.3","9.4","9.5","9.6"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}