reset id sqlserver code example

Example: sql server reset identity

DBCC CHECKIDENT ('table name', RESEED , 0)