clear database table and reseed code example
Example 1: primary key reset in SQL database
DBCC CHECKIDENT('TableName',Reseed,0)
Example 2: reseed sql table primary key
DBCC CHECKIDENT ('YourTableName', RESEED, 0);
DBCC CHECKIDENT('TableName',Reseed,0)
DBCC CHECKIDENT ('YourTableName', RESEED, 0);