Use the SQL Anywhere 12 plug-in to connect to the database as a user with RESOURCE or DBA authority.
Right-click a sequence generator and then choose 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.
Connect to the database as a user with RESOURCE or DBA authority.
Execute a CREATE SEQUENCE statement. See ALTER SEQUENCE statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|