Was this helpful?
ALTER SEQUENCE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The ALTER SEQUENCE statement changes sequence settings that were specified when the sequence was created.
The ALTER SEQUENCE syntax has the following format:
[EXEC SQL] ALTER SEQUENCE [schema.]sequence_name [sequence_options]
sequence_options
See CREATE SEQUENCE for details.
Permissions
You must have CREATE_SEQUENCE privilege.
You need NEXT privilege to retrieve values from a defined sequence. For information on the NEXT privilege, see GRANT (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
CREATE SEQUENCE
DROP SEQUENCE
Last modified date: 02/03/2024