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