You can reseed the Auto increment field to desire number by using following SQL statement [I think it is specific for SQL Server only] other Database have their own methods. DBCC CHECKIDENT (<TableName>, RESEED, 0) Works great for me on Sql Server 2008