Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing index type programmatically
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00769242
Message ID:
00769279
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform