updating an sqlite table

Question

I have an android app using an sqlite table. I need to add one more column to the table. I understand that it can be done in the onUpgrade method of DatabaseHelper class. My question is when is onUpgrade called? If i uinstall the app from my phone and reinstall then will the existing data be deleted?
Also is there any tool in Android Studio where I can see the exiting data in database?

James Watson · Answer

I used a firefox add-on to view and edit data in  a sqlite database.
In general, your own db data after app installing will be deleted after you reinstall an app unless there are some special codes in the app to save and reload db data when uninstalling and installing.