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
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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft