Sequence Overview

Sequences allow you to easily generate sequential values. You can use sequences to replace an IDENTITY column or user-generated integer column. The sequence will have similar functionality as these alternatives, but much better performance. Each sequence is a uniquely named database object that can be accessed only by sequence expressions.

You can perform the following tasks:

For more information about sequences, see Create Sequence in the SQL Reference topic in the Information Center Link to Information center.