Table with Identity column will not reset even if we delete all records and will not gets a fresh start at primary key 1. To reset the identity column, use this :
DBCC CHECKIDENT (tablename, reseed, 0)
Yes we have to use ‘0’ if we want the identity column to start from 1. So next time, if we insert a record, the identity column will be 1.
But if we already have 136 records but we want the identity column to start from 201 rather than 137, we have to use this:
DBCC CHECKIDENT (tablename, reseed, 200)
Remember, always 1 less then the value we want to start the identity value.