IndexType Enumeration
TOC
Collapse the table of content
Expand the table of content

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)

No code example is currently available or this language may not be supported.

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