A better approach is to have a class that extends SQLiteOpenHelper and override the onUpgrade and OnCreate methods. In the onUpgrade you drop the tables from your database, so when you increase the database version your program manages the update to the new db schema.
On Apr 17, 12:38 pm, Mi <[EMAIL PROTECTED]> wrote: > Tanks for helping. > > On Apr 11, 9:13 am, Ram <[EMAIL PROTECTED]> wrote: > > > > > You can use the following steps to remove the database > > > adb shell > > cd data > > cd data > > cd <package name> > > cd databases > > rm <database name> > > > if you'd just like to remove one table > > replace the last step with > > sqlite3 <database name> > > drop table <table name>; > > > For a clean start, it may be better to wipe out the whole db instead > > of just removing one table > > > On Apr 10, 11:27 pm, Mi <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I have created a database for my application using sqlite. When > > > continuing developing my application I want to change the tables in my > > > database. I want to remove a table. But how to do that? > > > If some one knows how to remove a database that would also be helpful. > > > > Tanks for helping.- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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] Announcing the new M5 SDK! http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
