On Sun, Jan 17, 2010 at 4:54 AM, Nick Retallack <[email protected]> wrote: > Normal tables have the 'if not exists' syntax, but virtual tables do > not. How can I create a virtual table iff it doesn't exist?
You could just try to create it and check the error. You could do something like "SELECT rowid FROM my_table LIMIT 1". If the table exists it will return one or zero items. -scott
