ALTER FULLTEXT INDEX

Change properties of a full-text index.

Syntax
      ALTER FULLTEXT INDEX ON Table Option

Options:
        ENABLE 
        DISABLE
        SET CHANGE_TRACKING { MANUAL | AUTO | OFF }
        ADD ( column  [TYPE COLUMN type_column ] 
           [ LANGUAGE language_term ]
           [ STATISTICAL_SEMANTICS ][,...n] )
              [WITH NO POPULATION ]
        ALTER COLUMN column_name
           { ADD | DROP } STATISTICAL_SEMANTICS
           [ WITH NO POPULATION ]

        DROP ( column [,...n] )
           [WITH NO POPULATION ] 
        START { FULL | INCREMENTAL | UPDATE } POPULATION
        { STOP | PAUSE | RESUME } POPULATION
        SET STOPLIST [ = ] { OFF | SYSTEM | stoplist_name }
           [ WITH NO POPULATION ]
        SET SEARCH PROPERTY LIST [ = ] { OFF | property_list_name }
           [ WITH NO POPULATION ]

Key:
    ENABLE      Activate the full-text index
    DISABLE     Stop gathering full-text index data.
    CHANGE_TRACKING   Maintain a list of changes to the indexed data.
    ADD/DROP    Add or remove columns from the index
    language_term     The locale identifier (LCID)

Examples

ALTER FULLTEXT INDEX ON MySchema.mytable ENABLE;
GO

“We can make good tests run fast but we can't make fast tests be good” ~ Ryan Tomayko

Related commands

CREATE FULLTEXT INDEX
DROP FULLTEXT INDEX
GRANT Object permissions