Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing index type programmatically
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00769242
Message ID:
00769279
Views:
18
This message has been marked as the solution to the initial question of the thread.
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform