2
.\" Title: DROP SEQUENCE
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "DROP SEQUENCE" "7" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
DROP_SEQUENCE \- remove a sequence
27
DROP SEQUENCE [ IF EXISTS ] \fIname\fR [, \&.\&.\&.] [ CASCADE | RESTRICT ]
32
removes sequence number generators\&. A sequence can only be dropped by its owner or a superuser\&.
37
Do not throw an error if the sequence does not exist\&. A notice is issued in this case\&.
42
The name (optionally schema\-qualified) of a sequence\&.
47
Automatically drop objects that depend on the sequence\&.
52
Refuse to drop the sequence if any objects depend on it\&. This is the default\&.
56
To remove the sequence
73
standard, except that the standard only allows one sequence to be dropped per command, and apart from the
79
CREATE SEQUENCE (\fBCREATE_SEQUENCE\fR(7)), ALTER SEQUENCE (\fBALTER_SEQUENCE\fR(7))