*snip*
>>
>>In addition to what Nick said, you could purchase Stonefield Database Toolkit that does this and a whole lot more!!!
>Larry, thanks for your reply but I thoungt Stonefield has only a Framework.
>Kind regrads
>Winfried

Winfried,
SDT is a tool that many frameworks have provided integrated solutions into themselves (e.g. Visual Maxframe Professional, Visual FoxExpress).

SDT is a utility that builds and holds information of about your database, tables, views, indexes and relations (Metadata). It provides functionality to do the following:

Automatically upgrade a database to the new version (new structures)

Correct errors like corrupt indexes or table headers

Rebuild indexes (automatically taking into account if the index is part of a FOREIGN KEY and resetting the relation)

etc., etc.

I enthusiastically recommend it!

Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao