IndexedColumns Property
The IndexedColumns property defines the list of columns participating in a Microsoft® SQL Server™ index.
Applies To
Index Object |
Syntax
object.IndexedColumns [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
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);
Remarks
The IndexedColumns property is implemented for index creation using SQL-DMO.
Note 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 catenate an additional column name to the property value. Instead, the application should build a catenated 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.