header(s) ON|OFF Turn display of headers on or off
explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off. If TABLE specified, only dump tables matching
databases List names and files of attached databases bail ON|OFF Stop after hitting an error. backup ?DB? FILE Backup DB (default 'main') to FILE For your convenience, here is that sqlite help output: On a related note, when you're using the SQLite command line tool (sqlite3), you can type '.help' to get a list of sqlite commands you can issue. i'm now back at my regular command line: show the schema of the 'projects' table:ĬREATE TABLE projects ( id integer primary key autoincrement, name text not null, type text not null, description text ) # sqlite3 data/data//databases/fptracker.db in this case my database is named fptracker: use the sqlite3 command to connect to your database. Here's an example of how this works, with comments shown before each command: You can show a list of SQLite tables by starting the Android adb shell (command line tool), and then properly invoking the sqlite3 command. Android/SQLite FAQ: How do I show a list of SQLite database tables from the Android command line (adb shell)?
