67
votes
12
answers
3K
views
List of tables, db schema, dump etc using the Python sqlite3 API
For some reason I can't find a way to get the equivalents of sqlite's interactive shell commands: .
60
votes
17
answers
1.4K
views
How can I list the tables in a SQLite database file that was opened with ATTACH?
What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I
55
votes
18
answers
1.4K
views
Select first row in each GROUP BY group?
As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Spec
