From: Manfred Stelzhammer on
Spam(a)ControlQ.com schrieb:
> On Mon, 26 Apr 2010, Gerhard Reithofer wrote:
>
>
>> thanks, I didn't read the docs thoroughly enough.
>> I was trying for the check for the existence of a table.
>>
>> c.l.t - the fastest support ;)
>
> try selecting for type = table from sqlite_master ...
>
> select * from sqlite_master ;
>
> If the table exists, you'll find it there ..
>
> Cheers,
> Rob Sciuk


......
set res [dbh exists {SELECT * FROM sqlite_master WHERE name='ftab'}]
......

Regards
Manfred