• Article

UniqueIndexForFullText 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 UniqueIndexForFullText property specifies the index used by Microsoft Search to identify rows uniquely in a full-text indexed table.

Syntax

object
.UniqueIndexForFullText [= value]

Parts

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

  • value
    A string that identifies an existing index by name

Data Type

String

Modifiable

Read/write when using the Table object to configure full-text indexing. Read-only when the Table object references a full-text indexed table.

Prototype (C/C++)

HRESULT GetUniqueIndexForFullText(SQLDMO_LPBSTR pRetVal);
HRESULT SetUniqueIndexForFullText(SQLDMO_LPCSTR pRetVal);

Note

SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Remarks

When using SQL-DMO to configure Microsoft Search full-text indexing, use the FullTextCatalog object to create and maintain Microsoft Search full-text catalogs. Use the Table object to create and maintain full-text indexes for a Microsoft SQL Server table.

The FullTextCatalogName, FullTextIndex, and UniqueIndexForFullText properties are used together to create a full-text index.

Use the ListAvailableUniqueIndexesForFullText method to enumerate available values for the UniqueIndexForFullText property.

Applies To:

Table Object