Drop Sequence

Valid in: SQL, ESQL

The Drop Sequence statement deletes a sequence from the database catalog.

For more information about sequences, see the Database Administrator Guide.

Syntax

The Drop Sequence statement has the following format:

[EXEC SQL] DROP SEQUENCE [schema.]sequence_name;

• sequence_name

  Specifies an existing sequence.

  The DBMS Server returns an error for each non-existent sequence name in a list, but does not abort the statement. Existing sequences for valid names in the list are removed.

Permissions

You must have the create_sequence privilege.

Locking and Sequences

In applications, sequences use logical locks that allow multiple transactions to retrieve and update the sequence value while preventing changes to the underlying sequence definition. The logical lock is held until the end of the transaction.

Related Statements

Alter Sequence

Create Sequence

Examples: Drop Sequence

The following example deletes sequence "XYZ":

drop sequence XYZ