I want to add a new Attribute to an existing Entity. The new Attribute will have unique values. I am using SQL Server 2012.
The new Attribute with a new Key named AK_AttributeName, and a unique non-clustered index.
I create a new Attribute and select “Unique (New AK)”. A new Key is created called PK_AttributeName. The Attribute Key is clustered.
First the new attribute shouldn’t be prefixed with “PK”. Second, it should not be a clustered index; SQL Server defaults the Primary Key as a clustered index. I also will get an error because I cannot have two clustered indexes.