truncate and reseed t-sql 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, 1)