> Hi,
> 
> How can I test for the existence of a single table in a SQLite database?
> 
> I tried sqlite3_get_table with "select * from persons" to test for the 
> existence of the table 'persons' and I had hoped the return value would be 
> SQLITE_NOTFOUND in the case of a non-existent table. However, I got 
> SQLITE_ERROR, which is less helpfull.
> 
> Any hints?
> 
> Regards, 
> 
> Olaf

Hello Olaf

You can access the sqlite_master table.

http://www.sqlite.org/cvstrac/wiki?p=InformationSchema

enjoy!

Philipp

Reply via email to