how to make sql auto change ID column incase of deleting code example Example: sql server reset auto increment DBCC CHECKIDENT (mytable, RESEED, 0)