From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-dropsequence.html | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 doc/src/sgml/html/sql-dropsequence.html (limited to 'doc/src/sgml/html/sql-dropsequence.html') diff --git a/doc/src/sgml/html/sql-dropsequence.html b/doc/src/sgml/html/sql-dropsequence.html new file mode 100644 index 0000000..332304d --- /dev/null +++ b/doc/src/sgml/html/sql-dropsequence.html @@ -0,0 +1,30 @@ + +DROP SEQUENCE
DROP SEQUENCE
Prev UpSQL CommandsHome Next

DROP SEQUENCE

DROP SEQUENCE — remove a sequence

Synopsis

+DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
+

Description

+ DROP SEQUENCE removes sequence number + generators. A sequence can only be dropped by its owner or a superuser. +

Parameters

IF EXISTS

+ Do not throw an error if the sequence does not exist. A notice is issued + in this case. +

name

+ The name (optionally schema-qualified) of a sequence. +

CASCADE

+ Automatically drop objects that depend on the sequence, + and in turn all objects that depend on those objects + (see Section 5.14). +

RESTRICT

+ Refuse to drop the sequence if any objects depend on it. This + is the default. +

Examples

+ To remove the sequence serial: + +

+DROP SEQUENCE serial;
+

Compatibility

+ DROP SEQUENCE 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. +

Prev Up Next
DROP SCHEMA Home DROP SERVER
\ No newline at end of file -- cgit v1.2.3