{"Entry":{"collection":"sql","key":"drop-tablespace","name":"DROP TABLESPACE","aliases":["droptablespace"],"metadata":{"aliases":["droptablespace"],"changed_in":["8.2","9.0","9.2"],"changes":[{"from":"7.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":[],"removed":[]},"status":"added","synopsis":null,"to":"8.0"},{"from":"8.1","purpose_changed":false,"renamed":null,"sections":{"added":["notes"],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["DROP TABLESPACE [ IF EXISTS ] tablespacename"],"removed":[]},"to":"8.2"},{"from":"8.2","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["description"],"removed":[]},"status":"changed","synopsis":null,"to":"8.3"},{"from":"8.4","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["DROP TABLESPACE [ IF EXISTS ] tablespace_name"],"removed":["DROP TABLESPACE [ IF EXISTS ] tablespacename"]},"to":"9.0"},{"from":"9.1","purpose_changed":false,"renamed":null,"sections":{"added":[],"changed":["parameters"],"removed":[]},"status":"changed","synopsis":{"added":["DROP TABLESPACE [ IF EXISTS ] name"],"removed":["DROP TABLESPACE [ IF EXISTS ] tablespace_name"]},"to":"9.2"}],"content_hash":"61e7f7954f6673deaeaa364d114cbbe97655c84e33bdc35d45cbb58c08c8940e","editorial":{},"first_version":"8.0","group":"schema","imported_at":"2026-09-30T17:43:37.885749+08:00","last_version":"20","name":"DROP TABLESPACE","object":"TABLESPACE","position":4008,"present_in":["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 tablespace","purpose_zh":"","related":["create-tablespace","alter-tablespace"],"slug":"drop-tablespace","source_rev":"a709ab85","synopsis":"DROP TABLESPACE [ IF EXISTS ] name","verb":"DROP"}},"Definition":{"Collection":"sql","Key":"drop-tablespace","SourceDatabase":"center","Version":"18","SourceTable":"sqlcmd","SourceKey":"drop-tablespace","SourceRevision":"a709ab85","Facts":{"anchor":"SQL-DROPTABLESPACE","file":"sql-droptablespace.html","lang":"en","name":"DROP TABLESPACE","purpose":"remove a tablespace","purpose_zh":"","related":["create-tablespace","alter-tablespace"],"sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP TABLESPACE\u003c/code\u003e removes a tablespace from the system.\u003c/p\u003e\u003cp\u003eA tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it can be dropped. It is possible that objects in other databases might still reside in the tablespace even if no objects in the current database are using the tablespace. Also, if the tablespace is listed in the \u003ca href=\"/docs/18/runtime-config-client.html#GUC-TEMP-TABLESPACES\"\u003etemp_tablespaces\u003c/a\u003e setting of any active session, the \u003ccode class=\"command\"\u003eDROP\u003c/code\u003e might fail due to temporary files residing in the tablespace.\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 tablespace 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 a tablespace.\u003c/p\u003e\u003c/dd\u003e\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"Parameters"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP TABLESPACE\u003c/code\u003e cannot be executed inside a transaction block.\u003c/p\u003e","key":"notes","title":"Notes"},{"html":"\u003cp\u003eTo remove tablespace \u003ccode class=\"literal\"\u003emystuff\u003c/code\u003e from the system:\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eDROP TABLESPACE mystuff;\n\u003c/pre\u003e","key":"examples","title":"Examples"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP TABLESPACE\u003c/code\u003e is a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e extension.\u003c/p\u003e","key":"compatibility","title":"Compatibility"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-tablespace/?v=18\" title=\"CREATE TABLESPACE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE TABLESPACE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/alter-tablespace/?v=18\" title=\"ALTER TABLESPACE\"\u003e\u003cspan class=\"refentrytitle\"\u003eALTER TABLESPACE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"See Also"}],"sections_same_as":"","slug":"18","synopsis_html":"DROP TABLESPACE [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e","synopsis_text":"DROP TABLESPACE [ IF EXISTS ] name"},"ManualEvidence":{},"MeasuredEvidence":{}},"Text":{"Collection":"sql","Key":"drop-tablespace","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"DROP TABLESPACE","Summary":"移除一个表空间","BodyHTML":"\u003cpre\u003eDROP TABLESPACE [ IF EXISTS ] name\u003c/pre\u003e\u003csection\u003e\u003ch2\u003e描述\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eDROP TABLESPACE\u003c/code\u003e从系统中移除一个表空间。\u003c/p\u003e\u003cp\u003e一个表空间只能由其拥有者或超级用户删除。删除前，该表空间中必须不含任何数据库对象。即使当前数据库中没有对象正在使用该表空间，其他数据库中的对象也可能仍然驻留在该表空间中。此外，如果任何活动会话的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TEMP-TABLESPACES\" rel=\"nofollow\"\u003etemp_tablespaces\u003c/a\u003e设置中列出了该表空间，那么由于该表空间中可能仍有临时文件，\u003ccode\u003eDROP\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\u003c/dl\u003e\u003c/div\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e注解\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eDROP TABLESPACE\u003c/code\u003e不能在事务块内执行。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e示例\u003c/h2\u003e\u003cp\u003e要从系统中移除表空间\u003ccode\u003emystuff\u003c/code\u003e：\u003c/p\u003e\u003cpre\u003eDROP TABLESPACE mystuff;\n\u003c/pre\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e兼容性\u003c/h2\u003e\u003cp\u003e\u003ccode\u003eDROP TABLESPACE\u003c/code\u003e是一种\u003cspan\u003ePostgreSQL\u003c/span\u003e扩展。\u003c/p\u003e\u003c/section\u003e\u003csection\u003e\u003ch2\u003e另见\u003c/h2\u003e\u003cspan\u003e\u003ca href=\"/wiki/sql/create-tablespace/?v=18\" title=\"CREATE TABLESPACE\" rel=\"nofollow\"\u003e\u003cspan\u003eCREATE TABLESPACE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/alter-tablespace/?v=18\" title=\"ALTER TABLESPACE\" rel=\"nofollow\"\u003e\u003cspan\u003eALTER TABLESPACE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e\u003c/section\u003e","SourceRevision":"1b5ca64c","ContentHash":"e01eda38a6d741128a74305d7c18d9a645447a3a71b8dd92e1a918a72986b133","Payload":{"purpose_zh":"移除一个表空间","sections":[{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP TABLESPACE\u003c/code\u003e从系统中移除一个表空间。\u003c/p\u003e\u003cp\u003e一个表空间只能由其拥有者或超级用户删除。删除前，该表空间中必须不含任何数据库对象。即使当前数据库中没有对象正在使用该表空间，其他数据库中的对象也可能仍然驻留在该表空间中。此外，如果任何活动会话的\u003ca href=\"/docs/18/runtime-config-client.html#GUC-TEMP-TABLESPACES\"\u003etemp_tablespaces\u003c/a\u003e设置中列出了该表空间，那么由于该表空间中可能仍有临时文件，\u003ccode class=\"command\"\u003eDROP\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\u003c/dl\u003e\u003c/div\u003e","key":"parameters","title":"参数"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP TABLESPACE\u003c/code\u003e不能在事务块内执行。\u003c/p\u003e","key":"notes","title":"注解"},{"html":"\u003cp\u003e要从系统中移除表空间\u003ccode class=\"literal\"\u003emystuff\u003c/code\u003e：\u003c/p\u003e\u003cpre class=\"programlisting\"\u003eDROP TABLESPACE mystuff;\n\u003c/pre\u003e","key":"examples","title":"示例"},{"html":"\u003cp\u003e\u003ccode class=\"command\"\u003eDROP TABLESPACE\u003c/code\u003e是一种\u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e扩展。\u003c/p\u003e","key":"compatibility","title":"兼容性"},{"html":"\u003cspan class=\"simplelist\"\u003e\u003ca href=\"/wiki/sql/create-tablespace/?v=18\" title=\"CREATE TABLESPACE\"\u003e\u003cspan class=\"refentrytitle\"\u003eCREATE TABLESPACE\u003c/span\u003e\u003c/a\u003e, \u003ca href=\"/wiki/sql/alter-tablespace/?v=18\" title=\"ALTER TABLESPACE\"\u003e\u003cspan class=\"refentrytitle\"\u003eALTER TABLESPACE\u003c/span\u003e\u003c/a\u003e\u003c/span\u003e","key":"see_also","title":"另见"}],"sections_same_as":"","synopsis_html":"DROP TABLESPACE [ IF EXISTS ] \u003cem class=\"replaceable\"\u003e\u003ccode\u003ename\u003c/code\u003e\u003c/em\u003e","synopsis_text":"DROP TABLESPACE [ IF EXISTS ] name"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20","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}