>I'm getting ready to rewrite the re-indexing routine of a large VFP 3.0 application. The old routine does not delete the .CDX files. It uses ALTER TABLE to drop the a table's primary key, then creates the primary key and other indexes (including foreign keys), then creates the table's triggers. After doing this for all tables, it (re)creates the database's RI.
>
>I remember an earlier posting (Barbara P.?) about deleting the .CDX files first, but didn't save the message and can't find it in my searches(I'm a basic member). Seems it was better than rebuilding the file.
>
>Does anyone have comments/suggestions?

i think there was a detailed rundown of these steps in one of the articles in the knowledgebase here (red dice)