>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?
AFAIK No. There is no warning of such in Help, I've never heard of it and, indeed, I['ve done many an ALTER TABLE without even considering this.
Howevr, if your alteration produces a new index, or, say, deletes a field that is already indexed, then obviously this will have an effect on your CDX file.
>
>Greetings in Advance,
>
>Ron
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.