Hi John.

>I just found out to my supprise that I can't directly read the info in a DBC.

You can using DBGETPROP().

>The more pressing thing is I need to create a program to index-reindex all my tables.

That's a different matter -- the DBC doesn't have any of the information necessary to create indexes, since it doesn't store the index expression, filter expression, ascending/descending, or collate sequence.

If you want to save yourself at least 80 hours to create a generic routine that will recreate indexes (I know, because this is how long it took me to write that routine alone), take a look at Stonefield Database Toolkit (SDT). In addition, to recreating indexes with a single method call, it can also repair corrupted table and memo header and update table structures at your client sites. PUTM members get a 10% discount on SDT.

Doug