SQLite Database Browser is an open source visual tool which can be used to create, design and edit database files compatible with SQLite. You can use this “SQLite Database Browse” when dealing with android internal databases. In my previous post i gave you the steps to export internal databases which are stored on the Emulator. This browser will simply allow you to view the structure and data stored in a particular database you have exported.
This browser is really helpful when creating internal databases for android applications in which case you need to debug.
“”If there are any errors in the query of creating tables, you’ll have to delete the database from the Emulator using the “File Explorer” view because although we change the query, the changes won’t apply until the existing database (with the same name) is on the Emulator. The reason is onCreate() of SQLiteOpenHelper class is called when the database is created for the first time(or this executed when application is launched for the first time after installation) and this is where the creation of tables and the initial population of the tables happens. Therefore, though you change the CREATE TABLE query it won’t replace the existing erroneous table.
SQLite Database Browser
- First open the database which you have exported. The “Database Structure” view will let you see all the data tables in the database.You can explore each table to view the structure of each table. I exported EmailProvider.db.
- Also you can view the data in each table from “Browse Data” tab.
Thank You! 🙂