How to Access SQLite From an Android Shell
- 1). Click the Windows "Start" button and type "cmd" in the search text box. Press "Enter" to open the command line.
- 2). Type "cd path" where "path" is the location of your Android SDK. Press "Enter" to point to the Android SDK files, which are typically in the "c:\android" directory.
- 3). Type "adb -s emulator-5554 shell" and press "Enter" to start the shell utility. The shell returns the location of the database and the version running in the SDK.
- 4). Type a query to view records. For instance, the following code shows all of the contacts stored on an Android device:
select * from contacts - 5). Press "Enter" to run the query. The list of records display in the shell utility.
Source...