Export (0) Print
Expand All
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 class IndexType

Member nameDescription
ClusteredIndexA clustered index.
NonClusteredColumnStoreIndexA non-clustered column store index.
NonClusteredHashIndexA nonclustered hash index.For more information, see In-Memory OLTP (In-Memory Optimization).
NonClusteredIndexA non-clustered index.
PrimaryXmlIndexA primary XML index.
SecondarySelectiveXmlIndexA secondary selective XML index.
SecondaryXmlIndexA secondary XML index.
SelectiveXmlIndexA selective XML index.
SpatialIndexA spatial index.

Community Additions

© 2015 Microsoft