Re: [sqlite] Create table IF NOT EXISTS

[Eugen Stoianovici]

Sripathi Raj wrote:

Hi,
Is the IF NOT EXISTS constraint supported? When I try to use it, I get an
error message saying that there is a syntax error at 'NOT'? I'm using Sqlite
3 on Windows and I'm trying to connect to it from Perl.

Thanks,

Raj

 

I can't use it either..same error so i guessed it is not suported. I 
didn't pay much attention to it though. I use c++ to connect to my db 
and i just catch an exception if the table already exists.
Hope this helps