Re: [pilot-db-list] Deletion of all records

[Tom D. <td...@us...>]

On Thursday 01 November 2001 12:04 am, mr...@cr... wrote:

> I've got a suggestion for a future revision: I have a database which
> accumulates records and then at the end of a specified time
> period, like the end of a month, I want to delete all the records.
> The only way I've found to do this is to delete each record, one at a
> time, which is a pain.  I don't want to delete the database, just the
> contents.  I did do it by exporting to a comma delim file, wiping out
> the contents of the comma delimited file, and importing the comma
> delim file, but that was almost as tedious as deleting each record.
> It would be nice if DB had an option to delete all records from a
> given database.

You could use the duplicate option with "Extent" set to "Design Only". Then 
delete the old database and use the new one.