To destroy a sequence generator, use the drop sequence command. You can list several sequences to be dropped at a time. The syntax for drop sequence is:
DROP SEQUENCE seq_name1, seq_name2, ...;
Example 5-35. Removing a Sequence
DROP SEQUENCE seq_invoice;
Before destroying a sequence, make sure that the sequence is not used by another table, function, or any other object in the database. If this check is not performed, then other operations that use the sequence will fail.