This is SQL Query for resetting Table Indentity :
1 | DBCC CHECKIDENT ([Table_Name], reseed, Reset_Number_To) |
place your Table Name in [Table_Name] and replace Reset_Number_To with number you want to start the identity for the next record, for example if you want your identity number start from 1, you replace Reset_Number_To with 0