This question already has an answer here:
- Reset IDENTITY value 3 answers
I have a table that is created as below.
CREATE TABLE [dbo].[Table1]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Title] [VARCHAR](255) NULL, ...
Lets say that the latest ID is 100 ( I have 100 records)
Is there a way to
ALTER this table's
IDENTITY column and change the auto increment value to now be 500?
So at the end i would have something like this ID 98, 99, 100, 500, 501, ....
I can not seem to find a solution for this in T-SQL