ALTER WORD INDEX

ALTER WORD INDEX indexname [{ADD | DROP} (colname, ...)] [ORDER BY (colname, ...)] [ UPDATE INDEX]

This statement can be used to change the schema for a word search index. It can

Add new columns to the index with the ADD clause
Drop existing columns.
Change the order of the results by replacing the ORDER BY column list. This does not affect the index itself.
Force a rebuild of the index to adjust for any previous ADD or DROP.

If a new column is added to the table it can also be added to a word index without any change to the index itself but if the column already exists and contains words when the column is added to the index then the index becomes invalid unless the UPDATE INDEX clause is used. Similarly if a COLUMN is dropped from the index it will require an UPDATE INDEX clause except for the unlikely case that there were no words in that column in the data.

Examples

ALTER WORD INDEX XX_01_DATA_W1 ADD (newcol)

Compatibility

Currently only implemented for SQL databases such as Oracle and PostgreSQL.