DROP SEQUENCE [ owner.] sequence-name

If the named sequence cannot be located, an error message is returned. When you drop a sequence, all synonyms for the name of the sequence are dropped automatically by the database server.

Must have DBA authority or be the owner of the sequence and have RESOURCE authority.

None

• Using a sequence to generate unique values
• ALTER SEQUENCE statement
• CREATE SEQUENCE statement

The following example drops a sequence named Test:

DROP SEQUENCE Test;