Skip to content

Instantly share code, notes, and snippets.

@getsadzeg
Last active May 15, 2019 09:52
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
SQL, SQLite: notes and commands

So, I dived into SQLite.

Showing tables: .tables

Showing a command which was used to create a table: .schema <table_name>

Showing an actual structure/info about table: PRAGMA TABLE_INFO(<table_name>); - note that this is a SQL command.

The most human-readable mode of output, I think, is done by this:

> .header on

> .mode column

Clearing screen on Linux: .shell clear

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment