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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
