• Article

UniqueIndexForFullText Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

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

Syntaxe

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);

[!REMARQUE]

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.

Notes

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