Updated on Kisan Patel
To specify see value and increment value to the auto increment column in the existing database table, we pass parameter to the IDENTITY.
The 1st parameter is the initial value and the 2nd parameter is the step value.
Alter table Users Add UserId int NOT NULL IDENTITY (1, 10)
In this case, the 1st row UserId value will be 1 and 2nd row UserId value will be 11 and so on as the increment parameter is 5.