See Also
You are here: Full-Text Indexing > Unlinking full-text index
ContentsIndexHome
PreviousUpNext
Unlinking full-text index
Unlinking full-text index

 

To unlink full-text index, drop table’s FREETEXT constraint. For instance, to unlink “debate_search” full-text index from table “debate”:

alter table debate
(
drop constraint debate_table_search
)

Unlink operation does not affect the content of the full-text index; however, new changes to the DB table will not be populated to the index.