This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the other supported versions listed above instead.
DROP SEQUENCE -- remove a sequence
DROP SEQUENCE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DROP SEQUENCE removes sequence number
- IF EXISTS
Do not throw an error if the sequence does not exist. A
notice is issued in this case.
The name (optionally schema-qualified) of a
Automatically drop objects that depend on the
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, and
apart from the IF EXISTS option, which
is a PostgreSQL extension.