Know Where Database is Stored in Android Studio

Introduction:

This article explains how to determine the location of the database created programmatically by you in Android Studio, in other words determine where the database is stored. You often need to see the database created by you so as to determine if it is created, if the values are being inserted or not and whether the table is being updated.

Step 1:

Run the application in which your database is being created. The emulator needs to be in a running state to be able to continue the following procedure. For running your application press "Shift+F10".

Step 2:

Wait until your emulator starts working. Now go to "Tools" -> "Android" -> "DDMS (monitor included)". You can also open the DDMS from:

Step 3:

You will get the following:

Step 4:

Open the File Explorer tab. You will get:

Step 5:

Open "data" -> "data" from this window:

Step 6:

Now open your project present in this data folder.

Step 7:

Click on "databases". Select the file with the same name as the name of your database. Click on "Pull a file from device". Now save the file with a ".db" extension.

Step 8:

Now open FireFox. Go to "Tools" -> "SQLite Manager".

Step 9:

From this window select "Database" -> "Connect database".

Step 10:

Now browse and select the ".db" file that you saved in step 7.

Step 11:

On the left hand side you will see the name of the table created by you under "tables". Double-click on it to see the data stored in the database.

Thank you :)