SQL Server – Reset Identity Column

If you have an identity column and would like to reset the seed number for it, execute the following if the table’s name is ‘Customer’.

DBCC CHECKIDENT('Customer', RESEED, 0)

Source