>>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)

Thanks, Dave. I checked the KB articles but didn't find anything on programaticy rebuilding CDX files. Did find several other usefull items, however.