[sqlite] Testing for table existence?

[Olaf Beckman Lapré]

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