2
$PostgreSQL: pgsql/doc/src/sgml/ref/drop_sequence.sgml,v 1.22 2005-01-04 00:39:53 tgl Exp $
3
PostgreSQL documentation
6
<refentry id="SQL-DROPSEQUENCE">
8
<refentrytitle id="SQL-DROPSEQUENCE-TITLE">DROP SEQUENCE</refentrytitle>
9
<refmiscinfo>SQL - Language Statements</refmiscinfo>
13
<refname>DROP SEQUENCE</refname>
14
<refpurpose>remove a sequence</refpurpose>
17
<indexterm zone="sql-dropsequence">
18
<primary>DROP SEQUENCE</primary>
23
DROP SEQUENCE <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
28
<title>Description</title>
31
<command>DROP SEQUENCE</command> removes sequence number generators.
36
<title>Parameters</title>
40
<term><replaceable class="PARAMETER">name</replaceable></term>
43
The name (optionally schema-qualified) of a sequence.
49
<term><literal>CASCADE</literal></term>
52
Automatically drop objects that depend on the sequence.
58
<term><literal>RESTRICT</literal></term>
61
Refuse to drop the sequence if any objects depend on it. This
70
<title>Examples</title>
73
To remove the sequence <literal>serial</literal>:
82
<title>Compatibility</title>
85
<command>DROP SEQUENCE</command> conforms with
86
<acronym>SQL:2003</acronym>, except that the standard only allows one
87
sequence to be dropped per command.
92
<title>See Also</title>
94
<simplelist type="inline">
95
<member><xref linkend="sql-createsequence" endterm="sql-createsequence-title"></member>
101
<!-- Keep this comment at the end of the file
106
sgml-minimize-attributes:nil
107
sgml-always-quote-attributes:t
110
sgml-parent-document:nil
111
sgml-default-dtd-file:"../reference.ced"
112
sgml-exposed-tags:nil
113
sgml-local-catalogs:"/usr/lib/sgml/catalog"
114
sgml-local-ecat-files:nil