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. Carlo ----- Original Message ---- From: Gerry Snyder <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Wednesday, May 21, 2008 11:54:45 AM Subject: Re: [sqlite] deleting 100,000 entries BareFeet wrote: > Hi Carlo, > > >> I want to clear the whole thing out(list)! >> > > Do you mean that you want to delete all rows from the "list" table? If > so, do this: > > delete from list; Or you could drop the table and then create it again. Gerry _______________________________________________ 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