>Hi all, I was thinking if it was possible to retrieve informations about table structures and indexes directly from the database.
>I know it contains all the information about the related tables but I don't know how to get them.
>What i was trying to do is a routine which allows me to rebuild tables and indexes. I am having more and more situations of corrupted tables. How come ? And above all how can I get rid of this ?
>

Maybe you should consider using Stonefield Database Toolkit (SDT) which does that already?