DB2 Version 9.7 for Linux, UNIX, and Windows

Dropping sequences

To delete a sequence, use the DROP statement.

About this task

A specific sequence can be dropped by using:

   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.

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

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

Before you begin

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