SQL Server auto-increment field reset back 0 points keep data and not keep data

 

 

--- Delete the original table data and reset the auto-incrementing column <br/> truncate table tablename <br/> -- reset the auto-incrementing field of the table in the truncate mode, retain data <br/> DBCC checkident (tablename, reseed, 0) <br/> -- set to allow explicit insertion of auto-incrementing columns <br/> set identity_insert tablename on <br/> -- of course, after the insertion is complete, remember to disable explicit insertion of auto-incrementing columns. <br /> set identity_insert tablename off