DROP SEQUENCE statement) 

A DROP SEQUENCE statement drops a number generator (sequence).

Syntax

<drop sequence statement> ::= DROP SEQUENCE [<owner>.]<sequence name>

owner, sequence name

Explanation

The current user must be the owner. The sequence name must identify a sequence of the current user.

The metadata of the sequence is removed from the catalog.