↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 8.1 reached end of support in November 2010. See the current version for supported releases.
PostgreSQL 8.1.23 Documentation
Prev Fast Backward Fast Forward Next

DROP SEQUENCE

Name

DROP SEQUENCE -- remove a sequence

Synopsis

DROP SEQUENCE name [, ...] [ CASCADE | RESTRICT ]

Description

DROP SEQUENCE removes sequence number generators.

Parameters

name

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

CASCADE

Automatically drop objects that depend on the sequence.

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.

See Also

CREATE SEQUENCE
Prev Home Next
DROP SCHEMA Up DROP TABLE

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.