In case we want to reset the values of the identity column in SQL Server, we can use the following command: DBCC CHECKIDENT (' ', RESEED, 22) The above will now start inserting values from 22+1=23 in the identify column of that table. In case we want to start the value as 1, we should use the command as: DBCC CHECKIDENT (' ', RESEED, 0)