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 listvalue
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.