Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

IndexedColumns Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The IndexedColumns property defines the list of columns participating in a Microsoft SQL Server index.


object
.IndexedColumns [= value]
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

String

Write-only

HRESULT SetIndexedColumns(SQLDMO_LPCSTR NewValue);

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

ms142641.note(en-US,SQL.90).gifNote:
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.

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.