updating identity values in SQL server

Best Dot Net Training Forums › Category: Training › updating identity values in SQL server
0 Vote Up Vote Down
Lakshmi G asked 5 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?