I will explain to change identity column seed value in SQL server or reseed identity column seed value of table in SQL server or how to change identity column value in SQL server.

DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)
Table_Name is name of your identity column table

RESEED specifies that the current identity value should be changed.

New_Reseed_Value is the new value to use as the current value of the identity column.

Example

EX: DBCC CHECKIDENT (‘UserMaster’, RESEED, 200)
Once we run above query it will reseed identity column value in UserMaster table and starts identity column value from “200”

Leave a Comment

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply