reset primary key number sql code example

Example: primary key reset in SQL database

DBCC CHECKIDENT('TableName',Reseed,0)