Filed under Sql Server

How to Reset identity column in SQL Server

If you are using an identity column in a table, Using DBCC CHECKIDENT, we can reseed (reset) the identity value of the table. If there are 50 rows existing in your table, If we want next record to have identity as 2000, we need to run following script. DBCC CHECKIDENT (yourtable, reseed, 1999) The next … Continue reading