How to reset Primary Key value of MS SQL Server table?
Just run following query: DBCC CHECKIDENT(‘YourTableName’, RESEED, 0) This one is often used after truncating table – under usual curcumstances without this command, next record you add will have primary key one higher than the latest added record (even you just truncated table).