I have SQL Server database and I want to change the identity column because it started
with a big number 10010
and it's related with another table, now I have 200 records and I want to fix this issue before the records increases.
What's the best way to change or reset this column?
Best Answer
Although there are some alternatives to achieve a similar kind of requirement.
Use DBCC CHECKIDENT which checks the current identity value for the table and if it's needed, changes the identity value.
Use IDENTITY_INSERT which allows explicit values to be inserted into the identity column of a table.
Example: