How to view tables created in a database

Question

Hi, I am new to android. I created a data base named as example.db with some tables in SqlLite. It worked fine. It was also created in data/data/com.mypackage.myapp/databases/example.db.

Now, I need to open that database and see the content in the database. How can I do this?

Answer 1

The Following only works on the Emulator or on a rooted phone.

Open your Command prompt (or Terminal)

1) Traverse to `\android-sdk-XXX\tools`
2) Type in `adb shell`
3) cd /data/data/com.mypackage.myapp/databases/
4) sqlite3 example.db

Now you have an SQL Interface for your Database.

Select * from TableName;