Reseed Table Primary Column

DBCC CHECKIDENT (‘TableName’, RESEED, 0);GO Note: 0 is the number to which you want to reset. It could be any number. For example if you have 200 records but you want to keep only 10 records and delete the rest, then you may reset the seed to 10 so that the next insert will be for record id 11.