How to Alter Sequence in MS-SQL

SQL Tutorial Home

Altering a sequence can be useful when you want to alter the next value of the sequence. The SQL statement to use is:

alter sequence emp_seq_id restart with 10100;

IN THIS PAGE