Full-Text Index Properties (Columns Page)

  • Unique index
    Select an index from the drop down list. The index must be a single-key-column, unique, non-nullable index.

  • Select the eligible columns that will be full-text indexed
    The grid displays the table columns that are available for this full-text index. Columns that are currently full-text indexed are checked. Optionally, you can check additional columns that you want to be full-text indexed.


    Ensure that at least one column is checked before you click OK.

    Available Columns

    The column name.

    Language for Word Breaker

    The language whose word breakers and stemmers perform linguistic analysis on all full-text indexed data.

    For more information, see Word Breakers and Stemmers and Best Practices for Choosing a Language When Creating a Full-Text Index.

    Type Column

    The name of the table column that holds the document type of the selected column. This is a read-only property.

See Also