<p>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 <code>ATTACH</code> command on the SQLite 3 command line tool?</p>

It appears you need to go through the
sqlite_master
table, like this:
```
```
SELECT * FROM dbname.sqlite_master WHERE type='table';
```
```
And then manually go through each table with a
```
SELECT
```
or similar to look at the rows.
The
```
.DUMP
```
and
```
.SCHEMA
```
commands doesn't appear to see the database at all.