drop_sequence.7

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· 7 代码 · 共 47 行

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "DROP SEQUENCE" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
DROP SEQUENCE \- remove a sequence

.SH SYNOPSIS
.sp
.nf
DROP SEQUENCE [ IF EXISTS ] \fIname\fR [, ...] [ CASCADE | RESTRICT ]
.sp
.fi
.SH "DESCRIPTION"
.PP
\fBDROP SEQUENCE\fR removes sequence number generators.
.SH "PARAMETERS"
.TP
\fBIF EXISTS\fR
Do not throw an error if the sequence does not exist. A notice is issued 
in this case.
.TP
\fB\fIname\fB\fR
The name (optionally schema-qualified) of a sequence.
.TP
\fBCASCADE\fR
Automatically drop objects that depend on the sequence.
.TP
\fBRESTRICT\fR
Refuse to drop the sequence if any objects depend on it. This
is the default.
.SH "EXAMPLES"
.PP
To remove the sequence serial:
.sp
.nf
DROP SEQUENCE serial;
.sp
.fi
.SH "COMPATIBILITY"
.PP
\fBDROP SEQUENCE\fR conforms to the SQL
standard, except that the standard only allows one
sequence to be dropped per command, and apart from the 
IF EXISTS option, which is a PostgreSQL 
extension. 
.SH "SEE ALSO"
CREATE SEQUENCE [\fBcreate_sequence\fR(7)], ALTER SEQUENCE [\fBalter_sequence\fR(l)]