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; DROP TABLE IF EXISTS xyzzy_stat; -- D. Richard Hipp drh at sqlite.org
