updating identity values in SQL server

Best Dot Net Training ForumsCategory: Trainingupdating identity values in SQL server
Lakshmi G asked 2 years ago

When  updating the Identity seed and increment allowed in SQL as below
Alter table customer
Alter column custId int Identity(10,5)
an error is shown “Incorrect syntax near the keyword ‘Identity’.”
Is it allowed to alter the @@identity property of a column in table?

Please follow and like us: