You may try:
SELECT NULL FROM sqlite_master WHERE tbl_name = 'table';
----- Original Message ----- From: "Asko Kauppi" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, February 10, 2005 5:08 PM
Subject: Re: [sqlite] would someone check my SQL..
Is it true that in SQLite one has no way to check (at CREATE TABLE statement itself) whether the table already is there? I got this from a person more accustomed to MySQL:
>in mysql, the CREATE TABLE command has a 'IF NOT EXISTS' option, but as i
>said, it's a non-standard extension.
>
>you could do a "SELECT * FROM table LIMIT 1" and check only if there's an
>error to verify the existence of the table.
Sure, I can do that but.. shouldn't there be a less elaborate way?
-ak
