I need to alter a sqlite3 table to add FTS3

I need the ability to add FTS3 to a sqlite3 table after it was created, not as it is created. Does anyone know the ALTER syntax to accomplish this?

---

SQLite does not support altering a table from a normal table to an FTS3 table. All you can do with ALTER TABLE is change the table name or add columns.

You will have to use CREATE VIRTUAL TABLE to make the FTS3 table and then copy the data.

链接地址: http://www.djcxy.com/p/19182.html

上一篇: SQLite FTS3查询中的字符？

下一篇: 我需要改变一个sqlite3表来添加FTS3