• Article

FullTextIndex Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The FullTextIndex property identifies those tables and columns participating in Microsoft Search full-text queries.

Syntax

object.FullTextIndex [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFullTextIndex(LPBOOL pRetVal);
HRESULT SetFullTextIndex(BOOL NewVal);

Remarks

If TRUE, the referenced column or table participates in full-text queries. FullTextIndex must be TRUE in a Table object before any Column object in the Columns collection can be set to TRUE.

If FALSE, the referenced column or table does not participate in full-text queries.