IsFullTextKey Property

SQL-DMO

SQL-DMO

IsFullTextKey Property

The IsFullTextKey property identifies the index used by Microsoft Search to support row identification.

Applies To
Index Object
Syntax

object.IsFullTextKey

Parts

object

Expression that evaluates to an object in the Applies To list

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetIsFullTextKey(LPBOOL pRetVal);

Remarks

When TRUE, the referenced index is used by Microsoft Search for row identification.

When FALSE, the referenced index is not used by Microsoft Search.

Microsoft Search requires that a single column identify rows participating in an index supporting full-text query. The column designated must contain unique, nonnull values and must participate in a PRIMARY KEY or UNIQUE key constraint. A table that contains a PRIMARY KEY constraint does not require a separate unique index for Microsoft Search configuration.

Use UniqueIndexForFullText to configure Microsoft Search full-text index key column use.

See Also

UniqueIndexForFullText Property