Remove all the rows in table and then execute below query. DECLARE @rows=1 DBCC CHECKIDENT(‘Tablename’, RESEED, @rows)