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



Reply via email to