Delete a sequence.
Syntax:
DROP SEQUENCE [schema.]sequence_name
Dropping and re-creating a sequence is a quick way to reset the next sequence number.
"I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones" ~ Albert Einstein
Related Oracle Commands:
CREATE SEQUENCE
ALTER SEQUENCE
DBA_SEQUENCES ALL_SEQUENCES USER_SEQUENCES