Purpose

Drops a sequence for a local table.

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 local objects.