in reply to SQLite Table Existence?

Hi,

SQLite has a table called sqlite_master
which holds details of all the tables you have created.

Try -

select * from sqlite_master;

to have a look at it.

J.C.

Replies are listed 'Best First'.
Re^2: SQLite Table Existence?
by Anonymous Monk on Sep 18, 2010 at 00:00 UTC
    That worked...great to know!
    Thanks

      It is not, however, what you want to use. Use tables or table_info from DBI. They will continue to work if you move to Pg or MySQL or whatever DBD engine you like. Every bit of engine dependent code you add is a future impediment to change and further amounts to an interface fork you will have to maintain when you could get it for free.