Text Size: Normal / Large

PostgreSQL 8.1.13 Documentation
Prev	Fast Backward		Fast Forward	Next

DROP SEQUENCE

Name

DROP SEQUENCE -- remove a sequence

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

DROP SEQUENCE removes sequence number generators.

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.

To remove the sequence serial:

DROP SEQUENCE serial;

DROP SEQUENCE conforms to the SQL standard, except that the standard only allows one sequence to be dropped per command.

No comments could be found for this page.

New comments cannot be added to old documentation versions.