<REFENTRY ID="SQL-DROPSEQUENCE"> <REFMETA> <REFENTRYTITLE> DROP SEQUENCE </REFENTRYTITLE> <REFMISCINFO>SQL - Language Statements</REFMISCINFO> </REFMETA> <REFNAMEDIV> <REFNAME> DROP SEQUENCE </REFNAME> <REFPURPOSE> Removes an existing sequence </REFPURPOSE> </refnamediv> <REFSYNOPSISDIV> <REFSYNOPSISDIVINFO> <DATE>1998-09-22</DATE> </REFSYNOPSISDIVINFO> <SYNOPSIS> DROP SEQUENCE <REPLACEABLE CLASS="PARAMETER">seqname</REPLACEABLE> [, ...] </SYNOPSIS> <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> Outputs </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. </para> </listitem> </varlistentry> </VARIABLELIST> </para> </REFSECT2> </REFSYNOPSISDIV> <REFSECT1 ID="R1-SQL-DROPSEQUENCE-1"> <REFSECT1INFO> <DATE>1998-09-22</DATE> </REFSECT1INFO> <TITLE> Description </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> Notes </TITLE> <PARA> The <command>DROP SEQUENCE</command> statement is a <productname>Postgres</productname> language extension. </PARA> <PARA> Refer to the <command>CREATE SEQUENCE</command> statement for information on how to create a sequence. </PARA> </REFSECT2> </refsect1> <REFSECT1 ID="R1-SQL-DROPSEQUENCE-2"> <TITLE> Usage </TITLE> <PARA> To remove sequence <literal>serial</literal> from database: </PARA> <ProgramListing> DROP SEQUENCE serial </ProgramListing> </REFSECT1> <REFSECT1 ID="R1-SQL-DROPSEQUENCE-3"> <TITLE> Compatibility </TITLE> <PARA> </PARA> <REFSECT2 ID="R2-SQL-DROPSEQUENCE-4"> <REFSECT2INFO> <DATE>1998-09-22</DATE> </REFSECT2INFO> <TITLE> SQL92 </TITLE> <PARA> There is no <command>DROP SEQUENCE</command> in <acronym>SQL92</acronym>. </PARA> </refsect2> </refsect1> </REFENTRY> <!-- Keep this comment at the end of the file Local variables: mode: sgml sgml-omittag:t 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: -->