We are unable to add ‘Unique Value’ and ‘Indexed’ constraints to identity column of a table which is already created. Trying to add it to the email field of the Users table. The changes are disabled and not able to add index and make the value as unique. Any help will be appreciated.
The identity column must have ‘Unique Value’ and ‘Indexed’ constraints by default, so if you “email” column is marked as identity these constraints must be selected, actually all the constraints must be selected and you can not deselect it.