sql reset primary key id code example

Example: primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)