Navigating through SQLite

Some useful info to setup and use SQLite on Windows. Install the binary from http://www.sqlite.org/download.html and store at any location on your PC, e.g. C:\SQLite3\. Append this path to your “User” environment variable PATH.

Logging into SQLite database:

sqlite3 dbFilename

Show tables in the database:

.tables

Show table schema:

.schema tableName
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s