IndexType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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
-
IndexType
- Attributes
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. |