drop_sequence.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:3k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <refentry id="SQL-DROPSEQUENCE">
  2.  <refmeta>
  3.   <refentrytitle>
  4.    DROP SEQUENCE
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    DROP SEQUENCE
  11.   </refname>
  12.   <refpurpose>
  13.    Removes an existing sequence
  14.   </refpurpose>
  15.  </refnamediv>
  16.  <refsynopsisdiv>
  17.   <refsynopsisdivinfo>
  18.    <date>1998-09-22</date>
  19.   </refsynopsisdivinfo>
  20.   <synopsis>
  21. DROP SEQUENCE <replaceable class="PARAMETER">name</replaceable> [, ...]
  22.   </synopsis>
  23.   
  24.   <refsect2 id="R2-SQL-DROPSEQUENCE-1">
  25.    <refsect2info>
  26.     <date>1998-09-22</date>
  27.    </refsect2info>
  28.    <title>
  29.     Inputs
  30.    </title>
  31.    <para>
  32.     <variablelist>
  33.      <varlistentry>
  34.       <term><replaceable class="PARAMETER">name</replaceable></term>
  35.       <listitem>
  36.        <para>
  37. The name of a sequence.
  38.        </para>
  39.       </listitem>
  40.      </varlistentry>
  41.     </variablelist>
  42.    </para>
  43.   </refsect2>
  44.   <refsect2 id="R2-SQL-DROPSEQUENCE-2">
  45.    <refsect2info>
  46.     <date>1998-09-22</date>
  47.    </refsect2info>
  48.    <title>
  49.     Outputs
  50.    </title>
  51.    <para>
  52.     <variablelist>
  53.      <varlistentry>
  54.       <term><computeroutput>
  55. DROP
  56.        </computeroutput></term>
  57.       <listitem>
  58.        <para>
  59. The message returned if the sequence is successfully dropped.
  60.        </para>
  61.       </listitem>
  62.      </varlistentry>
  63.      <varlistentry>
  64.       <term><computeroutput>
  65. WARN: Relation "<replaceable class="parameter">name</replaceable>" does not exist.
  66.        </computeroutput></term>
  67.       <listitem>
  68.        <para>
  69. This message occurs if the specified sequence does not exist.
  70.        </para>
  71.       </listitem>
  72.      </varlistentry>
  73.     </variablelist>
  74.    </para>
  75.   </refsect2>
  76.  </refsynopsisdiv>
  77.  <refsect1 id="R1-SQL-DROPSEQUENCE-1">
  78.   <refsect1info>
  79.    <date>1998-09-22</date>
  80.   </refsect1info>
  81.   <title>
  82.    Description
  83.   </title>
  84.   <para>
  85.    <command>DROP SEQUENCE</command> removes sequence number generators from the
  86.    data base. With the current implementation of sequences as
  87.    special tables it works just like the <command>DROP TABLE</command>
  88.    statement.
  89.   </para>
  90.   <refsect2 id="R2-SQL-DROPSEQUENCE-3">
  91.    <refsect2info>
  92.     <date>1998-09-22</date>
  93.    </refsect2info>
  94.    <title>
  95.     Notes
  96.    </title>
  97.    <para>
  98.     The <command>DROP SEQUENCE</command> statement is a
  99.     <productname>Postgres</productname>
  100.     language extension.
  101.    </para>
  102.    <para>
  103.     Refer to the <command>CREATE SEQUENCE</command> statement for
  104.     information on how to create a sequence.
  105.    </para>
  106.   </refsect2>
  107.  </refsect1>
  108.  <refsect1 id="R1-SQL-DROPSEQUENCE-2">
  109.   <title>
  110.    Usage
  111.   </title>
  112.   <para>
  113.    To remove sequence <literal>serial</literal> from database:
  114.    <programlisting>
  115. DROP SEQUENCE serial;
  116.    </programlisting>
  117.   </para>
  118.  </refsect1>
  119.  
  120.  <refsect1 id="R1-SQL-DROPSEQUENCE-3">
  121.   <title>
  122.    Compatibility
  123.   </title>
  124.   <para>
  125.   </para>
  126.   
  127.   <refsect2 id="R2-SQL-DROPSEQUENCE-4">
  128.    <refsect2info>
  129.     <date>1998-09-22</date>
  130.    </refsect2info>
  131.    <title>
  132.     SQL92
  133.    </title>
  134.    <para>
  135.     There is no <command>DROP SEQUENCE</command> in <acronym>SQL92</acronym>.
  136.    </para>
  137.   </refsect2>
  138.  </refsect1>
  139. </refentry>
  140. <!-- Keep this comment at the end of the file
  141. Local variables:
  142. mode: sgml
  143. sgml-omittag:nil
  144. sgml-shorttag:t
  145. sgml-minimize-attributes:nil
  146. sgml-always-quote-attributes:t
  147. sgml-indent-step:1
  148. sgml-indent-data:t
  149. sgml-parent-document:nil
  150. sgml-default-dtd-file:"../reference.ced"
  151. sgml-exposed-tags:nil
  152. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  153. sgml-local-ecat-files:nil
  154. End:
  155. -->