Partager via

  • Article

IndexedColumns 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 IndexedColumns property defines the list of columns participating in a Microsoft SQL Server index.

Syntaxe

object
.IndexedColumns [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A SQL Distributed Management Objects (SQL-DMO) multistring listing columns that will participate in the index

Data Type

String

Modifiable

Write-only

Prototype (C/C++)

HRESULT SetIndexedColumns(SQLDMO_LPCSTR NewValue);

Notes

The IndexedColumns property is implemented for index creation using SQL-DMO.

Notes

The IndexedColumns property is write-only. An attempt to retrieve the property value generates an error. The application cannot rely on the current value of the property in any way.For example, the application should not attempt to concatenate an additional column name with the property value. Instead, the application should build a concatenated string of column names and use that string to set the property value.

For more information about setting multistring parameters, see Using SQL-DMO Multistrings.

Applies To:

Index Object