On 11/4/15, ajm at zator.com <ajm at zator.com> wrote:
> The question: do is there any method to delete the old table without
> including the FTS3/4 modules to those users "in the field"?

Here is a hack.

Let the name of your FTS3 table be "xyzzy"

(1) Invoke "PRAGMA writable_schema=ON".  (Read the documentation about
the dangers thereof.  Do not complain if something goes wrong and you
corrupt your database.)

(2) Run "DELETE FROM sqlite_master WHERE name='xyzzy';"

(3) Set "PRAGMA writable_schema=OFF" again.

(4) Run the following:

DROP TABLE IF EXISTS xyzzy_content;
DROP TABLE IF EXISTS xyzzy_segments;
DROP TABLE IF EXISTS xyzzy_segdir;
DROP TABLE IF EXISTS xyzzy_docsize;

D. Richard Hipp
drh at sqlite.org

Reply via email to