how to reset the primary key in microsoft mysql server when it is deleted 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, 0);