TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

IndexType Enumeration

 

Specifies the type of an index.

For an In-Memory OLTP code sample, see SQL Server Management Objects Support for In-Memory OLTP.

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

public enum IndexType

Member nameDescription
ClusteredColumnStoreIndex

A clustered column store index.

ClusteredIndex

A clustered index.

NonClusteredColumnStoreIndex

A non-clustered column store index.

NonClusteredHashIndex

A nonclustered hash index.

For more information, see In-Memory OLTP (In-Memory Optimization).

NonClusteredIndex

A non-clustered index.

PrimaryXmlIndex

A primary XML index.

SecondarySelectiveXmlIndex

A secondary selective XML index.

SecondaryXmlIndex

A secondary XML index.

SelectiveXmlIndex

A selective XML index.

SpatialIndex

A spatial index.

Return to top
Show:
© 2016 Microsoft