SQL Server self-increment field reset

---Delete the original table data and reset the self-increment columntruncate TableTableName--truncate mode can also reset the self-increment field--resets the table's self-increment field, preserving the dataDBCCCheckident (Tablename,reseed,0) --setting allows explicit insertion of self-increment columnsSET Identity_insertTableName on --of course, insert. Remember to set do not allow explicit insertion of self-increment columnsSET Identity_insertTableNameOff

SQL Server self-increment field reset