DROP SEQUENCE SQL - Language Statements DROP SEQUENCE remove a sequence 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. Diagnostics DROP SEQUENCE Message returned if the sequence was successfully dropped. ERROR: sequence "name" does not exist Message returned if the specified sequence does not exist. Examples To remove the sequence serial: DROP SEQUENCE serial; Compatibility There is no DROP SEQUENCE statement in the SQL standard. See Also