Support Topics Documentation Slack YouTube Blog

Unable to add 'Unique Value' and 'Indexed' constraints to identity column


(Kevin Mc Clain) #1

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.


(Vladimir Upirov) #2

Hi Kevin

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.

Regards, Vlad