SQLite - SQLite command line

Start

The database file is test.db

sqlite3 test.db

Command

  • .tables: list out all tables.
  • .schema: the schema of how the tables were created in the database
  • .header on: column name be printed out as well
  • .quit to exit.

Powered by ComboStrap