Because Android Databases are SQLite Database it’s pretty standard so when you are developing your android application you can go in and explore your device to the database location and copy the database to your PC and start playing with it.
Getting the Database
In Eclipse as you have an emulator active and connected you will be able to browse all files on the device
you can do that by using the Android File Explorer if you can not see it go to window => show View => other and then in the Android Group Select File Explorer
when you select it you will be able to browse files
now go to
Data ==> Data ==>com.yourpackage
and in there you can find the database you created.
then on the top of this window click export
at that point you have your database field now what you need a tool that can edit and view your database
Editing the Database
the tool is Sqlite Browser that you can find on source forge
once you download that just double click it and open the database that you just imported and run all sql statements that you need on that.
the tool supports UTF-8 as the database ofcourse
in another post I’ll explain how you can include a database to your android app package.
