Reseting Identity

To reset Identity column in SQL use DBCC CHECKIDENT statement which will set the value to a wanted value.

Example:

USE myDatabaseName
GODBCC CHECKIDENT (myTableName, RESEED, 50)GO