How to view SQLite database files from a command line window

1. Locate the Platform-tools folder under the Androidsdk directory, and you will find a Adb.exe file under the directory.

Go to the system environment variable to set the value of path, add the path where the Adb.exe is located.

2. In the Command Line window, enter: "adb shell" into the console

3. Enter the cd/data/data/package name. Project name (lowercase)/databases/"(such as: Cd/data/data/co

m.keqi.test/databases/) Enter the storage path where the project file resides

4, you can use the "ls" command to view the files in this directory

5. Enter "Sqlite3 + database name. db" (for example: "Sqlite3 bookstore.db") to open the database

6. You can enter ". Table" to see which tables exist in the database

7. You can enter ". Schema" to view the Build table statement

8. Through SQL query statement "SELECT * FROM table name" (such as: "SELECT * from book")

How to view SQLite database files from a command line window