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

[<mr...@cr...>]

Just a follow-up message; this solution works - sort of.  The drawback to duplicating 
the design only is that the views appear to not be copied.  So, the structure of the 
database is copied to the new database, but any modified views are not.

On 1 Nov 2001 at 0:38, Tom Dyas wrote:

> 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.

======================
Michael Reich
mr...@cr...
======================