Thanks! it works!
>Did you try? Alter should replace existing index.
>
>>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
Dominican Republic, a Paradise in America