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 .