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.

Prerequisites

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
 Task

  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.

Results

The change takes effect immediately.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0