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.
CREATE SEQUENCE [create_sequence(7)]
|SQL - Language Statements||DROP SEQUENCE ()||2010-12-14|