Dropping sequences

To delete a sequence, use the DROP statement.

Before you begin

When dropping sequences, the authorization ID of the statement must have DBADM authority.

Restrictions

Sequences that are system-created for IDENTITY columns cannot be dropped by using the DROP SEQUENCE statement.

Procedure

To drop a specific sequence, enter:

   DROP SEQUENCE sequence_name

where the sequence_name is the name of the sequence to be dropped and includes the implicit or explicit schema name to exactly identify an existing sequence.

Results

Once a sequence is dropped, all privileges on the sequence are also dropped.