Updating a sequence w hoboken speed dating
For information about how sequences are created and how the sequence cache is managed, see CREATE SEQUENCE (Transact-SQL).
The MINVALUE for ascending sequences and the MAXVALUE for descending sequences cannot be altered to a value that does not permit the START WITH value of the sequence.
The downside of creating a sequence with a cache is that if a system failure occurs, all cached sequence values that have not be used, will be "lost".
This results in a "gap" in the assigned sequence values.
To change the data type, drop and create the sequence object.
A sequence is a user-defined schema bound object that generates a sequence of numeric values according to a specification.
[ CYCLE | NO CYCLE ] This property specifies whether the sequence object should restart from the minimum value (or maximum for descending sequence objects) or throw an exception when its minimum or maximum value is exceeded.INCREMENT BY The value that is used to increment (or decrement if negative) the sequence object’s base value for each call to the NEXT VALUE FOR function.