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

 

Create a sequence

 ♦  To 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 choose New » Sequence Generator.

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

 ♦  To create a sequence (SQL)

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

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

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

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0