Reset Identity Column Value to 1 in SQL Database

how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server.

DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)

 

 

Table_Name is name of your identity column table

RESEED specifies that the current identity value should be changed.

New_Reseed_Value is the new value to use as the current value of the identity column.

 

EXAMPLE: DBCC CHECKIDENT ('CustomerDetails', RESEED, 0)