Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » Primary key generation and concurrency » Use of a sequence to generate unique values


Altering a sequence

You can use Sybase Central to alter a sequence.


You must be the owner of the sequence or have one of the following privileges:

  • ALTER ANY SEQUENCE system privilege
  • ALTER ANY OBJECT system privilege
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Right-click a sequence generator and then click Properties.

    On the General tab, you can change the settings for the sequence. Clicking Restart Now executes an ALTER SEQUENCE...RESTART WITH n statement, where n corresponds to the value in the Start Value field.


The change takes effect immediately.

 See also