> 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