I need to affect existing indexes, not create new ones


>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