At 06:05 PM 10/2/2001 +0100, Ivan Prenosil wrote:

>If you are deleting all data from the database, then the fastest way is
> Drop the database.
> Create new database (just copy already prepared empty one with inactive
> indexes).
> Insert all records from the dBase tables (commit every 1000 records).
> Activate all indexes.

Or restore a backup over the existing database. The backup can preserve
any data that should be preserved.


Regards,

Ann
www.ibphoenix.com
We have answers.