SQL reset auto-increment primary key
After clearing a SQL Server table, if the primary key is auto-incremental, it will continue with the previous numbering. To reset the counter for the primary key, we can use the following command in SQL Management Studio: DBCC CHECKIDENT (‘<nome_tabella>’, RESEED, 0) This sets the current primary key value to zero, so the next record… Read More »