diff options
Diffstat (limited to 'doc/src/sgml/ref/drop_sequence.sgml')
| -rw-r--r-- | doc/src/sgml/ref/drop_sequence.sgml | 230 |
1 files changed, 114 insertions, 116 deletions
diff --git a/doc/src/sgml/ref/drop_sequence.sgml b/doc/src/sgml/ref/drop_sequence.sgml index eff237f7673..13673693743 100644 --- a/doc/src/sgml/ref/drop_sequence.sgml +++ b/doc/src/sgml/ref/drop_sequence.sgml @@ -1,155 +1,153 @@ -<REFENTRY ID="SQL-DROPSEQUENCE"> - <REFMETA> - <REFENTRYTITLE> +<refentry id="SQL-DROPSEQUENCE"> + <refmeta> + <refentrytitle> DROP SEQUENCE - </REFENTRYTITLE> - <REFMISCINFO>SQL - Language Statements</REFMISCINFO> - </REFMETA> - <REFNAMEDIV> - <REFNAME> + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> DROP SEQUENCE - </REFNAME> - <REFPURPOSE> + </refname> + <refpurpose> Removes an existing sequence - </REFPURPOSE> + </refpurpose> </refnamediv> - <REFSYNOPSISDIV> - <REFSYNOPSISDIVINFO> - <DATE>1998-09-22</DATE> - </REFSYNOPSISDIVINFO> - <SYNOPSIS> -DROP SEQUENCE <REPLACEABLE CLASS="PARAMETER">seqname</REPLACEABLE> [, ...] - </SYNOPSIS> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-22</date> + </refsynopsisdivinfo> + <synopsis> +DROP SEQUENCE <replaceable class="PARAMETER">name</replaceable> [, ...] + </synopsis> - <REFSECT2 ID="R2-SQL-DROPSEQUENCE-1"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPSEQUENCE-1"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Inputs - </TITLE> - <PARA> - </PARA> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">seqname</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - The name of a sequence. - </PARA> - </LISTITEM> - </VARLISTENTRY> - </variablelist> - </REFSECT2> - - <REFSECT2 ID="R2-SQL-DROPSEQUENCE-2"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + </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> Outputs - </TITLE> - <PARA> + </title> + <para> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <ReturnValue>DROP</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - The message returned if the sequence is successfully dropped. - </PARA> - </LISTITEM> - </VARLISTENTRY> - <VARLISTENTRY> - <TERM> - <ReturnValue>WARN: Relation "<replaceable class="parameter">seqname</replaceable>" does not exist.</ReturnValue> - </TERM> - <LISTITEM> - <PARA> - This message occurs if the specified sequence does not exist. + <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. </para> </listitem> </varlistentry> - </VARIABLELIST> + </variablelist> </para> - </REFSECT2> - </REFSYNOPSISDIV> - - <REFSECT1 ID="R1-SQL-DROPSEQUENCE-1"> - <REFSECT1INFO> - <DATE>1998-09-22</DATE> - </REFSECT1INFO> - <TITLE> + </refsect2> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-DROPSEQUENCE-1"> + <refsect1info> + <date>1998-09-22</date> + </refsect1info> + <title> Description - </TITLE> - <PARA> + </title> + <para> <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. - </PARA> - - <REFSECT2 ID="R2-SQL-DROPSEQUENCE-3"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + </para> + + <refsect2 id="R2-SQL-DROPSEQUENCE-3"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> Notes - </TITLE> - <PARA> + </title> + <para> The <command>DROP SEQUENCE</command> statement is a - <productname>Postgres</productname> + <productname>Postgres</productname> language extension. - </PARA> - <PARA> + </para> + <para> Refer to the <command>CREATE SEQUENCE</command> statement for information on how to create a sequence. - </PARA> - </REFSECT2> + </para> + </refsect2> </refsect1> - - <REFSECT1 ID="R1-SQL-DROPSEQUENCE-2"> - <TITLE> + + <refsect1 id="R1-SQL-DROPSEQUENCE-2"> + <title> Usage - </TITLE> - <PARA> + </title> + <para> To remove sequence <literal>serial</literal> from database: - </PARA> - <ProgramListing> -DROP SEQUENCE serial - </ProgramListing> - </REFSECT1> + + <programlisting> +DROP SEQUENCE serial; + </programlisting> + </para> + </refsect1> - <REFSECT1 ID="R1-SQL-DROPSEQUENCE-3"> - <TITLE> + <refsect1 id="R1-SQL-DROPSEQUENCE-3"> + <title> Compatibility - </TITLE> - <PARA> - </PARA> + </title> + <para> + </para> - <REFSECT2 ID="R2-SQL-DROPSEQUENCE-4"> - <REFSECT2INFO> - <DATE>1998-09-22</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-DROPSEQUENCE-4"> + <refsect2info> + <date>1998-09-22</date> + </refsect2info> + <title> SQL92 - </TITLE> - <PARA> + </title> + <para> There is no <command>DROP SEQUENCE</command> in <acronym>SQL92</acronym>. - </PARA> + </para> </refsect2> </refsect1> -</REFENTRY> - +</refentry> <!-- Keep this comment at the end of the file Local variables: mode: sgml -sgml-omittag:t +sgml-omittag:nil sgml-shorttag:t sgml-minimize-attributes:nil sgml-always-quote-attributes:t |