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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » Primary key generation and concurrency » Use of a sequence to generate unique values

 

Creating sequences

 Create 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. In the left pane, right-click Sequence Generators, and click New » Sequence Generator.

  3. Follow the instructions in the Create Sequence Generator Wizard.

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

  2. Execute a CREATE SEQUENCE statement.

  3. If other users need to have access to the sequence, you must execute a GRANT USAGE ON SEQUENCE statement.

 See also