ALTER FULLTEXT Statement

statement_ALTER_FULLTEXT ::= ALTER FULLTEXT [ scheme. ] identifier [ action { , action }... ]
action ::= ft_trigger_create | ft_trigger_delete
ft_trigger_create ::= ADD fulltext_trigger
ft_trigger_delete ::= DROP table_name column_id_document

ALTER FULLTEXT has two uses:

Creates or deletes fulltext triggers (requests for automatic document indexing) contained in the fulltext system marked with the specified identifier in the selected schema.
If no action is specified, it will rebuild the specified fulltext system.

Each occurrence of the ft_trigger_create clause adds a new fulltext trigger to the fulltext system. Each occurrence of the ft_trigger_delete clause deletes a trigger from the fulltext system (according to the specified parameters). For further details see the CREATE FULLTEXT statement.

Creating or deleting a fulltext trigger results in an automatic reindex of part of the fulltext system. There is no need to run the index manually.

Example

Add a column to an existing fulltext system pointing to external files. The format is not specified, because it will be detected automatically.

ALTER FULLTEXT FT_FORUM
 ADD FORUM_TAB ID FILE_APPX,1

Rebuild an existing fulltext system completely (erase the contents and reindex):

ALTER FULLTEXT FT_FORUM

See

CREATE FULLTEXT Statement

Fulltext in 602SQL

DROP FULLTEXT Statement