delete row with identity column sql server code example Example: reset identity column in sql server DBCC CHECKIDENT ('YourTableName', RESEED, 1)