DROP SEQUENCE

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