IndexedColumn Constructor (Index, String, Boolean)

Initializes a new instance of the IndexedColumn class on the specified index and with the specified name and order.

命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
Public Sub New ( _
    index As Index, _
    name As String, _
    descending As Boolean _
)

public IndexedColumn (
    Index index,
    string name,
    bool descending
)

public:
IndexedColumn (
    Index^ index, 
    String^ name, 
    bool descending
)

public IndexedColumn (
    Index index, 
    String name, 
    boolean descending
)

public function IndexedColumn (
    index : Index, 
    name : String, 
    descending : boolean
)

參數

• index
  An Index object that specifies the index in which the indexed column is participating.

• name
  A String value that specifies the name of the column.

• descending
  A Boolean value that specifies whether the index is sorted in descending or ascending order.

  If True, the index is sorted in descending order.

  If False, the index is sorted in ascending order.

備註

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

範例

How to: Create a Non-Clustered, Composite Index in Visual Basic .NET

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

IndexedColumn Class
IndexedColumn Members
Microsoft.SqlServer.Management.Smo Namespace

其他資源

Creating, Altering, and Removing Indexes
索引
CREATE INDEX (Transact-SQL)