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 ] [,...n] )
              [WITH NO POPULATION ]
        DROP ( column [,...n] )
           [WITH NO POPULATION ] 
        START { FULL | INCREMENTAL | UPDATE } POPULATION
        STOP 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)

Example

ALTER FULLTEXT INDEX ON MySchema.MyTable ENABLE;
GO

"The greatest Christmas gift can't be purchased in a store, ordered from a catalog, wrapped in a pretty package with a fancy bow ... but it can be seen in the eyes of a child, heard in the words of kindness & felt in the embrace of a friend" ~ anon

Related commands:

CREATE FULLTEXT INDEX
DROP FULLTEXT INDEX
GRANT Object permissions
Equivalent Oracle commands: Oracle Text / InterMedia / ConText


© Copyright SS64.com 1999-2014
Some rights reserved