drop_sequence.sgml 3.41 KB
Newer Older
1 2 3
<refentry id="SQL-DROPSEQUENCE">
 <refmeta>
  <refentrytitle>
4
   DROP SEQUENCE
5 6 7 8 9
  </refentrytitle>
  <refmiscinfo>SQL - Language Statements</refmiscinfo>
 </refmeta>
 <refnamediv>
  <refname>
10
   DROP SEQUENCE
11 12
  </refname>
  <refpurpose>
13
   Removes an existing sequence
14
  </refpurpose>
15
 </refnamediv>
16 17 18 19 20 21 22
 <refsynopsisdiv>
  <refsynopsisdivinfo>
   <date>1998-09-22</date>
  </refsynopsisdivinfo>
  <synopsis>
DROP SEQUENCE <replaceable class="PARAMETER">name</replaceable> [, ...]
  </synopsis>
23
  
24 25 26 27 28
  <refsect2 id="R2-SQL-DROPSEQUENCE-1">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
29
    Inputs
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
   </title>
   <para>
    <variablelist>
     <varlistentry>
      <term><replaceable class="PARAMETER">name</replaceable></term>
      <listitem>
       <para>
	The name of a sequence.
       </para>
      </listitem>
     </varlistentry>
    </variablelist>
   </para>
  </refsect2>

  <refsect2 id="R2-SQL-DROPSEQUENCE-2">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
50
    Outputs
51 52
   </title>
   <para>
53

54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
    <variablelist>
     <varlistentry>
      <term><computeroutput>
DROP
       </computeroutput></term>
      <listitem>
       <para>
	The message returned if the sequence is successfully dropped.
       </para>
      </listitem>
     </varlistentry>
     <varlistentry>
      <term><computeroutput>
WARN: Relation "<replaceable class="parameter">name</replaceable>" does not exist.
       </computeroutput></term>
      <listitem>
       <para>
	This message occurs if the specified sequence does not exist.
72 73 74
       </para>
      </listitem>
     </varlistentry>
75
    </variablelist>
76
   </para>
77 78 79 80 81 82 83 84
  </refsect2>
 </refsynopsisdiv>

 <refsect1 id="R1-SQL-DROPSEQUENCE-1">
  <refsect1info>
   <date>1998-09-22</date>
  </refsect1info>
  <title>
85
   Description
86 87
  </title>
  <para>
88 89 90 91
   <command>DROP SEQUENCE</command> removes sequence number generators from the
   data base. With the current implementation of sequences as
   special tables it works just like the <command>DROP TABLE</command>
   statement.
92 93 94 95 96 97 98
  </para>

  <refsect2 id="R2-SQL-DROPSEQUENCE-3">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
99
    Notes
100 101
   </title>
   <para>
102
    The <command>DROP SEQUENCE</command> statement is a
103
    <productname>Postgres</productname>
104
    language extension.
105 106
   </para>
   <para>
107 108
    Refer to the <command>CREATE SEQUENCE</command> statement for
    information on how to create a sequence.
109 110
   </para>
  </refsect2>
111
 </refsect1>
112 113 114

 <refsect1 id="R1-SQL-DROPSEQUENCE-2">
  <title>
115
   Usage
116 117
  </title>
  <para>
118
   To remove sequence <literal>serial</literal> from database:
119 120 121 122 123 124

   <programlisting>
DROP SEQUENCE serial;
   </programlisting>
  </para>
 </refsect1>
125
 
126 127
 <refsect1 id="R1-SQL-DROPSEQUENCE-3">
  <title>
128
   Compatibility
129 130 131
  </title>
  <para>
  </para>
132
  
133 134 135 136 137
  <refsect2 id="R2-SQL-DROPSEQUENCE-4">
   <refsect2info>
    <date>1998-09-22</date>
   </refsect2info>
   <title>
138
    SQL92
139 140
   </title>
   <para>
141
    There is no <command>DROP SEQUENCE</command> in <acronym>SQL92</acronym>.
142
   </para>
143 144
  </refsect2>
 </refsect1>
145
</refentry>
146 147 148 149

<!-- Keep this comment at the end of the file
Local variables:
mode: sgml
150
sgml-omittag:nil
151 152 153 154 155 156 157 158 159 160 161 162
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:
-->