in reply to determining table structure in SQLite database
Just for the record, you can also get the schema info direct, from the command line, using only the contents of the SQLite package... which, IIRC, has within its documentation, examples of how to do this.