See the end of this page: http://sqlite.org/lang_delete.html#truncateopt
On Mon, Sep 19, 2011 at 1:07 PM, Sreekumar TP <sreekumar...@gmail.com>wrote: > Hi, > > Which would be the quick way to clear all records in a table ( assumming > 100,000 records) ? > > 1. Delete * from table_name > 2. DROP TABLE table_name followed by CREATE TABLE > > -Sreekumar > _______________________________________________ > 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