Thanks Dirk. Yes, that would work.
Since I already have my tables logically spread across several files, I think I'll just keep and empty db file 'templates' handy, delete the files containing the tables I want cleared, and copy the templates to my working db files. Thanks for the suggestion. -Randy -----Original Message----- From: Dirk Jagdmann [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 11:24 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to delete all rows in table (TRUNCATE) without creating journal file(s)? > Is there a way to delete all rows in a table without SQLITE generating > temporary journal files? If you want to delete everything maybe a simple drop table foo; create table foo; will do it. -- ---> doj / cubic ----> http://cubic.org/~doj -----> http://llg.cubic.org
