how to reset the primary key in sql server code example Example: primary key reset in SQL database DBCC CHECKIDENT('TableName',Reseed,0)