CODEWITHSUNDEEP
androidsqliteupgradedatabase
Pentium10
Pentium10

Reputation: 208002

How to update table schema after an app upgrade on Android?

I have an unfinished application, but I want to address now the future update of it.

Suppose my app was upgraded, so when starts, detects that the database schema is outdated. So for each table has to update according to version number to the new schema while preserving all data.

I've read somewhere that on Android the SQLite database have some version number, and auto update stuff, but I didn't found an example for this specific issue.

How can this be accomplished on an Android app, using SQLite databases?

Is there a specific version number per table stored on Android SQLite databases? If so, how can I read it, and use for my above purpose?

Upvotes: 8

Views: 14279

Answers (1)

Christopher Orr
Christopher Orr

Reputation: 111625

SQLiteOpenHelper is your friend here.

You need to supply onCreate and onUpgrade methods.

Upvotes: 7

Related Questions