Articles Related

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.