Alternative for CREATE VIRTUAL TABLE IF NOT EXISTS

Question

According to CREATE VIRTUAL TABLE syntax, IF NOT EXISTS clause is not available.

How should I handle the case when the virtual table already exists without using DROP TABLE IF EXISTS?

I want to use rtree and fts module.

Answer 1

This is now supported since sqlite 3.7.11.

changelog