On Tue, 26 Jun 2007, John Fouhy wrote: > On 26/06/07, Terry Carroll <[EMAIL PROTECTED]> wrote: > > > > Is there any way of getting to the schema of an sqlite database from > > within Python? In particular, a list of tables in the DB. > > Try 'select * from sqlite_master'.
You rock. Thanks. And, now that I know that trick, googling on sqlite_master leads me to http://www.sqlite.org/faq.html#q7 which explains the format. Honest, I really did spend quite some time reading the sqlite docs and trying things; somehow I missed the FAQ. _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
