reseed sql table primary key code example

Example 1: primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)

Example 2: reseed sql table primary key

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

Example 3: reseed sql table primary key

DBCC CHECKIDENT ('YourTableName', RESEED, 0);