IndexType Enum

Definition

Namespace:

Microsoft.SqlServer.Management.Smo

Assembly:

Microsoft.SqlServer.SqlEnum.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

The enumeration specifies the type of the Index.

[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.IndexTypeConverter))]
public enum IndexType

[<System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.IndexTypeConverter))>]
type IndexType = 

Public Enum IndexType

Inheritance

Enum

IndexType

Attributes

TypeConverterAttribute

Fields

Name	Value	Description
ClusteredIndex	0	Clustered Index.
NonClusteredIndex	1	Nonclustered Index.
PrimaryXmlIndex	2	Primary XML Index.
SecondaryXmlIndex	3	Secondary XML Index.
SpatialIndex	4	Spatial Index.
NonClusteredColumnStoreIndex	5	Nonclustered Columnstore Index.
NonClusteredHashIndex	6	Nonclustered Hash Index.
SelectiveXmlIndex	7	Primary Selective Xml Index.
SecondarySelectiveXmlIndex	8	Secondary Selective Xml Index.
ClusteredColumnStoreIndex	9	Clustered Columnstore Index.
HeapIndex	10	Heap Index.