Another SQL tip I’ve found useful lately.
Here in this post we will see how you can Re-Seed a particular IDENTITY Column value.
There are times when you want to Re-Seed or reset the value of an identity column in a table.
When you delete a lot of records from a table and then try to insert more records. You would expect the identity values to start after the max value present after delete. But it preserves the max value ever present in the table and continues from there.
Or when you delete all records form a table and want to reseed the identity column value to start from afresh 1.
All you need is following statement, syntax:
DBCC CHECKIDENT (TableNameWithSingleQuotes, reSeed, NewseedValue);
This will start assigning new values starting from 101. But make sure that there…
View original post 65 more words