UniqueIndexForFullText Property
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]
Parts
object
Expression that evaluates to an object in the Applies To list
value
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-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™ 2000 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.