ALTER TABLE tablename ADD UNIQUE (Column1, Column2);
Best Regards,
Andrew
> Can someone explain how I can make a combination of two fields be a
> unique index.
>
> For example, in my table I have an OrderID field and a LineItems field.
> Individually the fields are not unique but when combined t
Can someone explain how I can make a combination of two fields be a
unique index.
For example, in my table I have an OrderID field and a LineItems field.
Individually the fields are not unique but when combined they are. I'd
like to create a unique index of the two together but not individually.
