Something like:

USE databsename!tablename EXCLUSIVE
ALTER TABLE tablename ADD PRIMARY KEY fld1 TAG fld1

See more on Alter Table in VFP Help.

>Is there a way to do it?
>
>For Example:
>table1 has index1 and index2 (regular type)
>I need to change Index1 to Primary, and Index2 to Candidate