UniqueIndexForFullText Property (SQL-DMO)

The UniqueIndexForFullText property specifies the index used by Microsoft Search to identify rows uniquely in a full-text indexed table.

Applies To

Table Object

Syntax

object.UniqueIndexForFullText [= value ]

Part	Description
object	Expression that evaluates to an object in the Applies To list
value	String identifying an existing index by name

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.

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-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 by using SysFreeString.

FullTextCatalogName Property	ListAvailableUniqueIndexesForFullText Method
FullTextIndex Property