Поделиться через

  • Статья

UniqueIndexForFullText Property

В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.

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

Синтаксис

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);
ПримечаниеПримечание

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.

Замечания

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