how to reset primary key in sql code example

Example 1: reset identity column in sql server

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

Example 2: primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)

Example 3: reseed sql table primary key

DBCC CHECKIDENT ('YourTableName', RESEED, 1)