Bagikan melalui

Index.IndexedColumns Property

  • Artikel

Gets a collection of IndexedColumn objects that represent all the columns participating in the index.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, GetType(IndexedColumn),  _
    SfcObjectFlags.None Or SfcObjectFlags.NaturalOrder Or SfcObjectFlags.Design Or SfcObjectFlags.Deploy)> _
Public ReadOnly Property IndexedColumns As IndexedColumnCollection 
    Get
'Usage
Dim instance As Index 
Dim value As IndexedColumnCollection 

value = instance.IndexedColumns

[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, typeof(IndexedColumn), 
    SfcObjectFlags.None|SfcObjectFlags.NaturalOrder|SfcObjectFlags.Design|SfcObjectFlags.Deploy)]
public IndexedColumnCollection IndexedColumns { get; }

[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::OneToAny, 
    typeof(IndexedColumn), SfcObjectFlags::None|SfcObjectFlags::NaturalOrder|SfcObjectFlags::Design|SfcObjectFlags::Deploy)]
public:
property IndexedColumnCollection^ IndexedColumns {
    IndexedColumnCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, 
    typeof(IndexedColumn), SfcObjectFlags.None|SfcObjectFlags.NaturalOrder|SfcObjectFlags.Design|SfcObjectFlags.Deploy)>]
member IndexedColumns : IndexedColumnCollection

function get IndexedColumns () : IndexedColumnCollection

Property Value

Type: Microsoft.SqlServer.Management.Smo.IndexedColumnCollection
An IndexedColumnCollection object that represents all the columns participating in the index.

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)