reseed sql table primary key
snippet in sql

reseed sql table primary key

user9257

DBCC CHECKIDENT ('YourTableName', RESEED, 1)

primary key reset in SQL database

user5799

DBCC CHECKIDENT('TableName',Reseed,0)

reseed sql table primary key

user8846

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