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

John Fouhy john at fouhy.net
Tue Jun 26 07:26:08 CEST 2007


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'.

-- 
John.


More information about the Tutor mailing list