Petite Abeille wrote: > > Is it possible to use 'if not exists' in conjunction with the creation > DDL for a virtual table? >
No, its not possible. The syntax of a "create table" statement is shown here http://www.sqlite.org/lang_createtable.html and that for a "create virtual table" statement is shown here http://www.sqlite.org/lang_createvtab.html. The virtual table statement does not allow the optional "if not exists" clause. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users