A sequence is a user-defined schema-bound object that generates
a sequence of numeric values according to the specification with
which the sequence was created. The sequence of numeric values
is generated in an ascending or descending order at a defined
interval and may cycle (repeat) as requested. Sequences, unlike
identity columns, are not associated with tables. An application
refers to a sequence object to receive its next value. The
relationship between sequences and tables is controlled by the
application. User applications can reference a sequence object
and coordinate the values keys across multiple rows and tables.
A sequence is created independently of the tables by using the
CREATE SEQUENCE statement. Options enable you to control the
increment, maximum and minimum values, starting point, automatic
restarting capability, and caching to improve performance. For
information about the options, see CREATE SEQUENCE. Unlike
identity column values, which are generated when rows are
inserted, an applicatio