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:

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).

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.