You can use Sybase Central to alter a sequence.
You must be the owner of the sequence or have one of the following privileges:
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|