Re: How can one detect which tables are in a database?

Roger Binns <[email protected]> Sun, 17 Sep 2006 22:05:34 -0700

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

I use this single statement.

 select count(*) from sqlite_master where type='table' and name=?

It has the advantage of returning a zero or one which you can use as a bool.

Roger

lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.