>I have a program that rebuilds indexes in a free table. It deletes the 'cdx' file and then reads index information stored in another table to rebuild the index file. If index changes need to be made, they are modified in the information table and then the rebuild program is run.
> Tables that belong to a database, however, have their index information store in the database dbc file as well. In order for the program to rebuild the indexes in database table it would also have to update the dbc file. This looks like it will work but does not seem to be the best approach. Is there a better way to delete and rebuild indexes in a database table?
Purchase SDT (Stonefield Database Toolkit) from
www.stonefield.com - it does this and a whole lot more, and is worth every penny you spend on it, since you can incorporate its functionality for reindexing, packing, repairing, validating and updating databases anbd free tables intoyour own applications.