android SQLite DB 열기

• [안드로이드] 내부 SQLite3 데이터베이스 보기
• 안드로이드 SQLite DB파일 열기
• View contents of database file in Android Studio
• SQLSCout

Pull

adb pull /data/data/com.android.test/databases/testdb.db ~/.

Pull 권한이 안된다면

adb shell
$ run-as com.domain.package
$ chmod 777 databases
$ chmod 777 databases/databse_name

Shell

adb shell
sqlite3 /data/data/com.domain.test/databases/testdb.db
SQLite version 3.x.xx yyyy-mm-dd H:i:s
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
testdb            android_metadata

sqlite> .schema testdb

sqlite> .schema testdb

sqlite> .exit

root@android:/ # exit

Select Device Shell

$adb devices
List of devices attached
G1AXB70596xx	device

$ adb -s G1AXB70596xx shell

SQLScout

라이선스가 필요하다.