So I was stuck trying to debug a problem with a missing table in an Android app. I knew the table was in the original database, but I had to be sure it was in the actual database the emulator was using. The easiest way to check this is as follows:
1. Run the adb program. Use “adb shell” to create a shell in which you can access the emulator.
2. Switch to the directory where the database is located. The “cd data/data/<application package name>/databases should do it.
3. Execute sqlite3 <database name>
4. Run whatever SQL commands you need to do in order to prove your sanity.
Big ups go out to Chris Kopec for his excellent tutorial located here.