Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter Table
Message
De
27/05/1997 10:02:47
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, États-Unis
 
 
À
25/05/1997 10:22:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00033451
Message ID:
00033683
Vues:
47
>No, it's is primary key, not an regular index.
>
>>> I can't find any clues how to do this in VFP help. All Sql command doesn't
>>> use for create index tag. But why not Index?
>>
>>I've found this in help on Alter table / Example:
>>
>>* Example 2
>>ALTER TABLE customer ADD PRIMARY KEY cust_id TAG cust_id
>>
>>ALTER TABLE customer ALTER COLUMN cust_id c(5) PRIMARY KEY
>>
>>I guess the second line is the syntax Jerry was looking for. Some other
>>key type may be used as well.


Somebody already answered the question for me. I was making a bigger deal out of it than I needed to.
In order to create a regular index, I used 'INDEX ON myfield TAG myfield'. It makes sense since when
using ALTER TABLE, you already have to have the DBC opened exclusive.

Jerryt
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform