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

Question

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?

Answer 1

SQLiteOpenHelper is your friend here.

You need to supply onCreate and onUpgrade methods.