I need to create a unique primary key on multiple columns. I have
tried to do it in the tables create statement and that works, however if
I do it in an alter table she seems to moan? I am running version
Here is the code which I am having some trouble with:
e alter table EstimateAttributeValue
add UNIQUE PRIMARY KEY (estimateId, attributeId)
this works if I leave the unique out, but then I can insert duplicates.
Is there a cleaner alternitive than creating a unique index on
the same column as the primary key?
if possible could you please send some sample code to do this.
Thank you kindly