Re: [sqlite] Best way to check for existence of a table?

[D. Richard Hipp]

On Sun, 2005-02-13 at 22:58 +0000, Richard Boyd wrote:
>  
> 
> I need a way to check if a table exists from some C code. 

SELECT count(*) FROM sqlite_master WHERE
  name=<tablename> AND type='table';
-- 
D. Richard Hipp <[EMAIL PROTECTED]>