I have a set of data in sqlite database. Is it possible to view the database in device? I have checked in ddms mode, the data is empty in file explorer.
How to Access Sqlite Database in a New Application on Android Device ?
Resolved
SQL
CM
Community Member September 09, 2015
2 replies
1,641 views
Reviewed by moderators
2 Answers
you can try this: n1. adb shelln2. cd /go/to/databasesn3. sqlite3 database. dbn4. in the prompt, type. tables; n
. tables this will give you all the tables in the database. dbnn5. select * from table1n
If you are using a Real Device and it is not rooted then it is not possible to see your data base in File Explorer because due to some security reason that folder is locked in android system. And if you are using it in an emulator, you will find it in File Explorer /data/data/your package name/databases/your database. db