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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Using transactions and isolation levels » Primary key generation and concurrency » Using a sequence to generate unique values

 

Alter a sequence

 ♦  To 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 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.

 ♦  To alter a sequence (SQL)
  1. Connect to the database as a user with RESOURCE or DBA authority.

  2. Execute a CREATE SEQUENCE statement. See ALTER SEQUENCE statement.