I'm a huge fan of the command line tool. At work we use it extensively when prototyping. We're probably amongst the less technically sophisticated of users, so the ability to quickly script an approach using a few text files is something we value hugely. It's a great way of weaning people off spreadsheets in situations where data volumes stretch their capabilities. But I sometimes wonder if it could be an even bigger plus with a little more attention. This seems to me like a worthy area for enhancement if it is technically "easy."
If we had strong C skills I'd be inclined to have a go. [But I can say that in full safety!] On Mon, Jun 13, 2011 at 4:09 PM, Jay A. Kreibich <[email protected]> wrote: > On Sun, Jun 12, 2011 at 05:29:32PM -0400, ap scratched on the wall: > > When I attach additional DB's with ATTACH DATABASE how can I view the > schema > > or tables in the (non main) databases? > > > > > > > > ATTACH DATABASE 'C:\temp\test.db' AS T > > > > .schema T > > > > .tables T > > > > Produce no results. > > You can't. The CLI dot-commands only show results for the > "main" and "temp" databases. > > -j > > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Intelligence is like underwear: it is important that you have it, > but showing it to the wrong people has the tendency to make them > feel uncomfortable." -- Angela Johnson > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
