Instead of managing all this on your own you can use a tool like Stonfield Database Toolkit to do that for you

Arnon

>Just to add my .02 worth. Run GENDBC and have a look at its output. Also beware - dropping the .cdx will drop all of your RI which has to be rebuilt. ALTER TABLE is very useful for us short sighted folk.
>
>>You are correct -- in the "old days" (FPW 2.x), this was fairly easy to do, and most of us built some sort of "Rebuild Indices" routine into our applications to take care of this problem. We also learned to avoid the REINDEX command...it provides a quick fix in most cases, but was technically unsound for various reasons.
>>
>>In VFP, however, one cannot just blow away tags and/or .CDX's as in FPW. The .DBC contains data about certain types of indices and referential integrity, and you need to consider this when you rebuild an index. You may want to look into the ALTER TABLE command...it will enable you to rebuild primary, candidate, and foreign keys, as well as do various other things to your tables. However, be forewarned about ALTER TABLE...be careful, and be sure that you know what you are doing.
>>