Hi,
You can drop the table by writing DROP TABLE tablename IF EXISTS
But after that it is good to do a VACUUM (info about that in the link
below).
I.e the code might look like:
private SQLiteDatabase db;
private static final String TABLE_NAME = "name_of_table";
try{db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
db.execSQL("VACUUM");}
catch(SQLException sqle){....}
Here is a good link to the SQLite documentation: http://www.sqlite.org/lang.html
BR
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
