Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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
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