ListAvailableUniqueIndexesForFullText Method

SQL-DMO

SQL-DMO

ListAvailableUniqueIndexesForFullText Method

The ListAvailableUniqueIndexesForFullText method returns a NameList object that enumerates those indexes defined on a table capable of supporting Microsoft Search full-text indexing.

Applies To
Table Object
Syntax

object.ListAvailableUniqueIndexesForFullText( ) as NameList

Parts

object

Expression that evaluates to an object in the Applies To list

Prototype (C/C++)

HRESULT ListAvailableUniqueIndexesForFullText(
LPSQLDMONAMELIST* ppUniqueIndexNames);

Returns

A NameList object that enumerates Microsoft® SQL Server™ 2000 indexes.

Remarks

To support a full-text index on a column, Microsoft Search requires a unique constraint defined on the table that contains the column. The constraint must be either UNIQUE or PRIMARY KEY, but must be defined on a single column.

The ListAvailableUniqueIndexesForFullText method identifies indexes supporting constraints that can provide a unique value for Microsoft Search indexing.