Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter Table
Message
From
27/05/1997 10:02:47
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
25/05/1997 10:22:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00033451
Message ID:
00033683
Views:
49
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform