How can I list the tables in a SQLite database file that was opened with ATTACH?

Question

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Answer 1

There are a few steps to see the tables in an SQLite database:

1. List the tables in your database:

   .tables 

2. List how the table looks:

   .schema tablename 

3. Print the entire table:

   SELECT * FROM tablename; 

4. List all of the available SQLite prompt commands:

   .help