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
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1