Introduction:
Here I will explain how to change identity column seed value in SQL server 2008 or reseed identity column seed value of table in SQL server or how to change identity column value in SQL server.
Here I will explain how to change identity column seed value in SQL server 2008 or reseed identity column seed value of table in SQL server or how to change identity column value in SQL server.
Description:
In
previous post I explained how set identity or auto increment column in SQL server, Custom auto increment column in sql server, resent identity column in sql server and many articles
related to SQL server. Now I will explain how to change or reseed
identity column value in SQL
server. I have a one table in that I
set identity property on particular column and inserted few records in table while
inserting new records identity column value automatically increased that would
be like this