mssql set primary key counter code example

Example: primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)