[Tutor] Getting at sqlite schema info from within Python?

[Terry Carroll]

On Tue, 26 Jun 2007, John Fouhy wrote:

> On 26/06/07, Terry Carroll <carroll at tjc.com> 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.