SQL Server – Reset Identity Column If you have an identity column and would like to reset the seed number for it, execute the following if the table’s name is ‘Customer’. DBCC CHECKIDENT('Customer', RESEED, 0) Source