There are a few steps to see the tables in an SQLite database:
-
List the tables in your database:
.tables -
List how the table looks:
.schema tablename -
Print the entire table:
SELECT * FROM tablename; -
List all of the available SQLite prompt commands:
.help