Suppose you have a table with 10 rows in it(below is the table structure).
You have deleted all the rows, now when you insert further data in it. It will generate the id 11. Now if you want to reset the identity column to 0. What will you do ?
Execute the code below against a table and it will reset your identity column to 0 :-
DBCC CHECKIDENT ('table_name', RESEED, 0)
Thanks and Regards