How to change the Identity Column value ?

Before Change the Identity value(ProductID column) from the Product Table

 

 

-- To set the new identity value on the Product Table

DBCC CHECKIDENT ('Product', RESEED, 10)

Execution Results as follows

Checking identity information: current identity value '10', current column value '10'.
DBCC execution completed.

To insert a new record in the product table, to test the next identity value

insert into Product values ('Mat',200)

After Change the Identity value