Opening Sqlite Db On Command Prompt

Friends, I am working on Sqlite DB and I want to open, view or create databases through the ADB shell command. I've written the following commands in command prompt cd C:\android-

Solution 1:

You can use sqlite3 command to connect to database from adb shell. Find example of sqlite3 form Android Developers. This will open an sql prompt where you can execute standard commands supported. Another link which explains creating a database, creating table and viewing its contents all from command prompt (adb shell) is here.