CODEWITHSUNDEEP
sqlitealter-tablefts3
user221014
user221014

Reputation:

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?

Upvotes: 1

Views: 459

Answers (1)

Doug Currie
Doug Currie

Reputation: 41180

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.

Upvotes: 1

Related Questions