Menu
This may be a dumb question, but why can't I change the Identity Specification or (Is Identity) from 'No' to 'Yes'?
614
You cannot change the IDENTITY property of a column on an existing table. What you can do is add a new column with the IDENTITY property, delete the old column, and rename the new column with the old columns name.
You can not update identity column.SQL Server does not allow to update the identity column unlike what you can do with other columns with an update statement. Although there are some alternatives to achieve a similar kind of requirement.
Check your column data type.
If it is varchar then you can't change identity column.
To change identity column, it should have int data type.
69
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
