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