Skip to content

Instantly share code, notes, and snippets.

@linktoming

linktoming/gist:1604335

Created January 13, 2012 02:50
Show Gist options
  • Save linktoming/1604335 to your computer and use it in GitHub Desktop.
Save linktoming/1604335 to your computer and use it in GitHub Desktop.
Download ZIP
Useful Sqlite3 Command
Raw
gistfile1.txt
1. List all the tables
sqlite> .tables
2. List the structure of a table
sqlite> PRAGMA table_info([ZCLIENT]);
3. Exit
sqlite> .exit
4. Open a database file
$ sqlite3 pathofyourfile.sqlite
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment