>I need to create a primary key compound by two fields. I was trying to do that in the GUI but it doesn't work (i.e. Field1 + Field2).
>
>Then I found this in the
MSDN Online library:
> ALTER TABLE MyTable ADD PRIMARY KEY Field1 tag Field1
>
>How can I to include two fields in the above statement?
>
>
>Thanks all!!!
In addition to Larry's reply: the collective wisdom says, that it's better to use surrogate PKs. Compound index may be a candidate in this case.
If it's not broken, fix it until it is.
My Blog