Online Documentation for SQL Manager for SQL server

Sequences

A Sequence is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values. When a sequence number is generated, the sequence is incremented, independently of the transaction committing or rolling back. If two users concurrently increment the same sequence, then the sequence numbers each user acquires may have gaps, because sequence numbers are being generated by the other user. One user can never acquire the sequence number generated by another user. After a sequence value is generated by one user, that user can continue to access that value regardless of whether the sequence is incremented by another user.

Sequence Editor allows you to define sequence properties. It opens automatically when you create a new sequence and is available on editing an existing one (see Create sequence and Edit sequence for details).

To open a sequence in the Sequence Editor, double-click it in the DB Explorer tree.

• Using Navigation bar and Toolbar
• Creating/editing sequence

• Viewing DDL definition
• Setting object permissions