Thanks Keith. Carlo
----- Original Message ---- From: Keith Goodman <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, May 21, 2008 12:45:42 PM Subject: Re: [sqlite] deleting 100,000 entries On Tue, May 20, 2008 at 8:59 PM, Carlo S. Marcelo <[EMAIL PROTECTED]> wrote: > That means I save space right? Because the space all the original entries are > still intact when I run the delete command? Whereas dropping table clears > everything (since we are re-creating it)? > > I'm only assuming this is what dropping table does. > > It would be cool to know how to drop tables thanks Gerry. sqlite> drop list; Dropping the table does not save space by default. Take a look at the vacuum command: http://www.sqlite.org/lang_vacuum.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
