CODEWITHSUNDEEP
androiddatabasesqlite
baTimá
baTimá

Reputation: 544

How do i check my SQLite database values in eclipse?

I created a app and added some tables, columns and some info in it and i want to check it, how do i do it?

Upvotes: 0

Views: 7748

Answers (6)

CAM-Dev
CAM-Dev

Reputation: 186

I believe that Motodev Studio allows for database browsing. http://developer.motorola.com/tools/motodevstudio/?utm_campaign=mhp01092012&utm_source=mhp&utm_medium=mws Or you could just export the database to your desktop, for example, and then browse it with the Firefox SQLite plugin.

Upvotes: 0

Wosh
Wosh

Reputation: 1625

If you are running your app on the phone, you cant access your internal storage unless it is rooted. If that is your case simply run the app on a virtual device, then go to DDMS perspective, from there data/data/yourapplication/database/urdb.db then pull the db on the your computer and explore it with the tools stated above.

Upvotes: 3

Rahmathullah M
Rahmathullah M

Reputation: 2716

Switch to DDMS perpective(Window > Open Perpective > DDMS).

Find out your database's db file in file explorer. Select it.

Export it by clicking on the button in the top right corner of the UI.(ie; Pull the file from from the device)

Use SQLiteman to view the data.

Hope it helps.

Upvotes: 3

Rakesh
Rakesh

Reputation: 4127

This post on how to access sqlite database on Android, will help you out. There is one mozilla plugin which can also help you to see the database.

Upvotes: 0

Rajendra
Rajendra

Reputation: 1698

use Sqlite Database Browser tool to see the your Sqlite database. Go to the DDMS and export your application database and open this database in Sqlite Database Browser

Upvotes: 0

G_S
G_S

Reputation: 7110

you can query the database from your android code to do this. check the link http://codinglookseasy.blogspot.in/2012/08/sqlite-database.html where you can find creating table , inserting data into tables and retrieving it . Or use SQLite Database Browser http://sqlitebrowser.sourceforge.net/ to check the values without using the code

Upvotes: 0

Related Questions