1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>DROP TABLESPACE</title>
<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
<meta name="generator" content="DocBook XSL Stylesheets V1.70.0">
<link rel="start" href="index.html" title="PostgreSQL 8.1.4 Documentation">
<link rel="up" href="sql-commands.html" title="SQL Commands">
<link rel="prev" href="sql-droptable.html" title="DROP TABLE">
<link rel="next" href="sql-droptrigger.html" title="DROP TRIGGER">
<link rel="copyright" href="ln-legalnotice.html" title="Legal Notice">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="refentry" lang="en">
<a name="sql-droptablespace"></a><div class="titlepage"></div>
<div class="refnamediv">
<h2>Name</h2>
<p>DROP TABLESPACE — remove a tablespace</p>
</div>
<a name="id772878"></a><div class="refsynopsisdiv">
<h2>Synopsis</h2>
<pre class="synopsis">DROP TABLESPACE <em class="replaceable"><code>tablespacename</code></em></pre>
</div>
<div class="refsect1" lang="en">
<a name="id772901"></a><h2>Description</h2>
<p> <code class="command">DROP TABLESPACE</code> removes a tablespace from the system.
</p>
<p> A 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 may still reside
in the tablespace even if no objects in the current database are using
the tablespace.
</p>
</div>
<div class="refsect1" lang="en">
<a name="id772923"></a><h2>Parameters</h2>
<div class="variablelist"><dl>
<dt><span class="term"><em class="replaceable"><code>tablespacename</code></em></span></dt>
<dd><p> The name of a tablespace.
</p></dd>
</dl></div>
</div>
<div class="refsect1" lang="en">
<a name="id772940"></a><h2>Examples</h2>
<p> To remove tablespace <code class="literal">mystuff</code> from the system:
</p>
<pre class="programlisting">DROP TABLESPACE mystuff;</pre>
<p>
</p>
</div>
<div class="refsect1" lang="en">
<a name="id772961"></a><h2>Compatibility</h2>
<p> <code class="command">DROP TABLESPACE</code> is a <span class="productname">PostgreSQL</span>
extension.
</p>
</div>
<div class="refsect1" lang="en">
<a name="id772981"></a><h2>See Also</h2>
<span class="simplelist"><a href="sql-createtablespace.html">CREATE TABLESPACE</a>, <a href="sql-altertablespace.html">ALTER TABLESPACE</a></span>
</div>
</div></body>
</html>
|
