Purpose

The Drop Sequence statement drops a sequence for local tables.

Syntax

DROP SEQUENCE sequence_name [IF EXISTS] [RESTRICT|CASCADE]

where:

sequence_name
specifies the name of a sequence to drop.
IF EXISTS
specifies that an error is not to be returned if the sequence does not exist.
RESTRICT
is in effect by default, meaning that the drop fails if any view refers to the sequence.
CASCADE
silently drops all dependent database objects.