IndexedColumns Property
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。
The IndexedColumns property defines the list of columns participating in a Microsoft SQL Server index.
語法
object
.IndexedColumns [= value]
Parts
object
An expression that evaluates to an object in the Applies To listvalue
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);
備註
The IndexedColumns property is implemented for index creation using SQL-DMO.
[!附註]
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.