Drop Sequence

The Drop Sequence statement drops a sequence for local tables.

Grammar

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.