Altering sequences

 Alter a sequence (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with RESOURCE or DBA authority.

  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.

 Alter a sequence (SQL)

  1. Connect to the database as a user with RESOURCE or DBA authority.

  2. Execute an ALTER SEQUENCE statement.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1