Copy a database file from your device to your host machine:.Pull the database file from the device and start sqlite3: To use sqlite3 locally, instead of within a shell, Within the /data/data directory hierarchy. Note: You need root access to the file system to view files # sqlite3 /data/data/.rssexample/databases/rssitems.db To exit and return to the adb remote shell, enterįor example: $ adb -s emulator-5554 shell You can also optionally specify a full path to a database that you want to explore.Įmulator/device instances store SQLite databases in the directoryĬommands in the shell. From the remote shell, start the sqlite3 tool by entering the following command:.
Enter a remote shell by entering the following command:.You the ability to execute SQLite commands on the fly.ĭocumentation for full details.
schema to print the SQL CREATE statement for an existing table. dump to print out the contents of a table and SQLite databases created by Android applications.
From a remote shell to your device or from your host machine, use the sqlite3 command-line program to manage
