]> granicus.if.org Git - postgresql/blobdiff - doc/src/sgml/ref/drop_domain.sgml
Make the SQL command synopses appear less random.
[postgresql] / doc / src / sgml / ref / drop_domain.sgml
index 5196ae4b899ef44bb6c006bc6455f55e166bc779..e87f7e2752a31517d987abc4b6e940fa32334796 100644 (file)
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_domain.sgml,v 1.9 2002/11/21 23:34:43 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/drop_domain.sgml,v 1.13 2003/09/22 00:16:58 petere Exp $
 PostgreSQL documentation
 -->
 
 <refentry id="SQL-DROPDOMAIN">
  <refmeta>
-  <refentrytitle id="SQL-DROPDOMAIN-TITLE">
-   DROP DOMAIN
-  </refentrytitle>
+  <refentrytitle id="SQL-DROPDOMAIN-TITLE">DROP DOMAIN</refentrytitle>
   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  </refmeta>
+
  <refnamediv>
-  <refname>
-   DROP DOMAIN
-  </refname>
-  <refpurpose>
-   remove a user-defined domain
-  </refpurpose>
+  <refname>DROP DOMAIN</refname>
+  <refpurpose>remove a domain</refpurpose>
  </refnamediv>
+
+ <indexterm zone="sql-dropdomain">
+  <primary>DROP DOMAIN</primary>
+ </indexterm>
+
  <refsynopsisdiv>
-  <refsynopsisdivinfo>
-   <date>1999-07-20</date>
-  </refsynopsisdivinfo>
-  <synopsis>
-DROP DOMAIN <replaceable class="PARAMETER">domainname</replaceable> [, ...]  [ CASCADE | RESTRICT ]
-  </synopsis>
-
-  <refsect2 id="R2-SQL-DROPDOMAIN-1">
-   <refsect2info>
-    <date>2002-02-24</date>
-   </refsect2info>
-   <title>
-    Inputs
-   </title>
-   <para>
-    <variablelist>
-     <varlistentry>
-      <term><replaceable class="PARAMETER">domainname</replaceable></term>
-      <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 there are any dependent objects.
-       This is the default.
-       </para>
-      </listitem>
-     </varlistentry>
-    </variablelist>
-   </para>
-  </refsect2>
-
-  <refsect2 id="R2-SQL-DROPDOMAIN-2">
-   <refsect2info>
-    <date>2002-02-24</date>
-   </refsect2info>
-   <title>
-    Outputs
-   </title>
-   <para>
-    <variablelist>
-     <varlistentry>
-      <term><computeroutput>
-DROP DOMAIN
-       </computeroutput></term>
-      <listitem>
-       <para>
-       The message returned if the command is successful.
-       </para>
-      </listitem>
-     </varlistentry>
-     <varlistentry>
-      <term><computeroutput>
-ERROR:  RemoveDomain: type '<replaceable class="parameter">domainname</replaceable>' does not exist
-       </computeroutput></term>
-      <listitem>
-       <para>
-       This message occurs if the specified domain (or type) is not found.
-       </para>
-      </listitem>
-     </varlistentry>
-    </variablelist>
-   </para>
-  </refsect2>
+<synopsis>
+DROP DOMAIN <replaceable class="PARAMETER">name</replaceable> [, ...]  [ CASCADE | RESTRICT ]
+</synopsis>
  </refsynopsisdiv>
 
- <refsect1 id="R1-SQL-DROPDOMAIN-1">
-  <refsect1info>
-   <date>2002-02-24</date>
-  </refsect1info>
-  <title>
-   Description
-  </title>
-  <para>
-   <command>DROP DOMAIN</command> will remove a user domain from the
-   system catalogs.
-  </para>
+ <refsect1>
+  <title>Description</title>
+
   <para>
-   Only the owner of a domain can remove it.
+   <command>DROP DOMAIN</command> will remove a domain.  Only the
+   owner of a domain can remove it.
   </para>
  </refsect1>
 
+ <refsect1>
+  <title>Parameters</title>
+
+  <variablelist>
+   <varlistentry>
+    <term><replaceable class="PARAMETER">name</replaceable></term>
+    <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>
+
  <refsect1 id="SQL-DROPDOMAIN-examples">
   <title>Examples</title>
+
   <para>
-   To remove the <type>box</type> domain:
+   To remove the domain <type>box</type>:
 
 <programlisting>
 DROP DOMAIN box;
@@ -131,13 +83,9 @@ DROP DOMAIN box;
  <refsect1 id="SQL-DROPDOMAIN-compatibility">
   <title>Compatibility</title>
   
-  <refsect2 id="R2-SQL-DROPDOMAIN-sql92">
-   <title>
-    SQL92
-   </title>
-
-   <para></para>
-  </refsect2>
+  <para>
+   This command conforms to the SQL standard.
+  </para>
  </refsect1>
 
  <refsect1 id="SQL-DROPDOMAIN-see-also">