Reset Identity Column in SQL Server

added by MDubey
4/10/2013 12:16:05 PM

0 Kicks, 63 Views

If you deleted all the records from the table and there is an Identity column in your table, You will see that when you insert a new record in your table then Identity column value starts from the last value of that column incremented by your step value.