Reset Identity column in SQL Server


The following line resets the Identity value for the Customer table to 0 so that the next record added starts at 1.

Syntax:

DBCC CHECKIDENT('Customer', RESEED, 0)


Visit here for more information:


Thanks :)