sql server does truncate table reset identity 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);