DROP SEQUENCE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP SEQUENCE statement deletes a sequence from the database catalog.
For more information about sequences, see the Database Administrator Guide.
The DROP SEQUENCE statement has the following format:
[EXEC SQL] DROP SEQUENCE [IF EXISTS] [schema.]sequence_name;
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist and the user matches the schema.
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 CREATE_SEQUENCE privilege to drop a sequence.
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
Last modified date: 08/29/2024