Re: [pysqlite] Listing Tables

On Thursday 23 July 2009, Roger Binns said something like:
> Siegfried G=FCndisch wrote:
> > I want to list all the tables in a database with a simple command.
>
>   http://www.sqlite.org/pragma.html#schema

There is also the sqlite_master table:

SELECT name FROM sqlite_master
WHERE type=3D'table'
ORDER BY name;

See: http://www.sqlite.org/faq.html#q7

j

-- =

Joshua Kugler
Part-Time System Admin/Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/ =A0ID 0xDB26D7CE