tsql reset primary key code example

Example: primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)