The .databases command generates a table of all the
currently attached databases. The format of the table is:
| Column name | Column type | Meaning |
|---|---|---|
seq
| Integer | Database sequence number |
name
| Text | Logical database name |
file
| Text | Path and name of database file |
The first database (sequence number 0)
should always have the name main. This is the database that was first
opened. The second database (sequence number 1), if present,
should always be the temp
database, where any temporary objects are created. Any attached
databases will be listed after that.