Tag Archives: How to reset an identity value

SQL Server IDENTITY Reset

SQL Server IDENTITY Reset In this tutorial i will let you know about SQL Server IDENTITY Reset.In SQL server table that have IDENTITY property are auto incremented according to IDENTITY incremental value set by us.You have noticed that whenever you deleted all records from your table, next insert start IDENTITY column not from 0 or 1.To