Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter Table
Message
From
11/05/2007 07:19:49
 
 
To
11/05/2007 07:08:37
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01224484
Message ID:
01224492
Views:
16
>Hi all,
>
>I have to do an Alter Table command on an indexed table. Am I loosing the index when I do that? And if so, how can I avoid it?
>
>Greetings in Advance,
>
>Ron

No, you won't lose the index (whether a tag or an index file), unless you delete a column involved with the index expression.
If you alter a column type or rename the column , you will also lose a index which uses the column in it's expression.

Lennert
Previous
Reply
Map
View

Click here to load this message in the networking platform