drop_domain.sgml 2.57 KB
Newer Older
1
<!--
2
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_domain.sgml,v 1.15 2005/05/02 01:52:50 neilc Exp $
3 4 5 6 7
PostgreSQL documentation
-->

<refentry id="SQL-DROPDOMAIN">
 <refmeta>
8
  <refentrytitle id="SQL-DROPDOMAIN-TITLE">DROP DOMAIN</refentrytitle>
9 10
  <refmiscinfo>SQL - Language Statements</refmiscinfo>
 </refmeta>
11

12
 <refnamediv>
13 14
  <refname>DROP DOMAIN</refname>
  <refpurpose>remove a domain</refpurpose>
15
 </refnamediv>
16

Peter Eisentraut's avatar
Peter Eisentraut committed
17 18 19 20
 <indexterm zone="sql-dropdomain">
  <primary>DROP DOMAIN</primary>
 </indexterm>

21
 <refsynopsisdiv>
22
<synopsis>
23
DROP DOMAIN <replaceable class="PARAMETER">name</replaceable> [, ...]  [ CASCADE | RESTRICT ]
24
</synopsis>
25 26
 </refsynopsisdiv>

27 28 29
 <refsect1>
  <title>Description</title>

30
  <para>
31 32
   <command>DROP DOMAIN</command> will remove a domain.  Only the
   owner of a domain can remove it.
33 34 35
  </para>
 </refsect1>

36 37 38 39 40
 <refsect1>
  <title>Parameters</title>

  <variablelist>
   <varlistentry>
41
    <term><replaceable class="PARAMETER">name</replaceable></term>
42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
    <listitem>
     <para>
      The name (optionally schema-qualified) of an existing domain.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><literal>CASCADE</></term>
    <listitem>
     <para>
      Automatically drop objects that depend on the domain (such as
      table columns).
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><literal>RESTRICT</></term>
    <listitem>
     <para>
      Refuse to drop the domain if any objects depend on it.  This is
      the default.
     </para>
    </listitem>
   </varlistentry>
  </variablelist>
 </refsect1>

71 72
 <refsect1 id="SQL-DROPDOMAIN-examples">
  <title>Examples</title>
73

74
  <para>
75
   To remove the domain <type>box</type>:
76 77

<programlisting>
Tom Lane's avatar
Tom Lane committed
78
DROP DOMAIN box;
79 80 81 82 83 84
</programlisting>
  </para>
 </refsect1>

 <refsect1 id="SQL-DROPDOMAIN-compatibility">
  <title>Compatibility</title>
85
  
86 87 88
  <para>
   This command conforms to the SQL standard.
  </para>
89 90 91 92 93 94
 </refsect1>

 <refsect1 id="SQL-DROPDOMAIN-see-also">
  <title>See Also</title>

  <simplelist type="inline">
Peter Eisentraut's avatar
Peter Eisentraut committed
95
   <member><xref linkend="sql-createdomain" endterm="sql-createdomain-title"></member>
96
   <member><xref linkend="sql-alterdomain" endterm="sql-alterdomain-title"></member>
97 98
  </simplelist>
 </refsect1>
99

100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
</refentry>

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
sgml-omittag:nil
sgml-shorttag:t
sgml-minimize-attributes:nil
sgml-always-quote-attributes:t
sgml-indent-step:1
sgml-indent-data:t
sgml-parent-document:nil
sgml-default-dtd-file:"../reference.ced"
sgml-exposed-tags:nil
sgml-local-catalogs:"/usr/lib/sgml/catalog"
sgml-local-ecat-files:nil
End:
-->