IndexOptionKind Enumeration

 

Specifies the possible index options.

Namespace:   Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

public enum class IndexOptionKind

Member nameDescription
AllowPageLocks

The kind of index option is AllowPageLocks.

AllowRowLocks

The kind of index option is AllowRowLocks.

BucketCount

The kind of index option is BucketCount.

DataCompression

The kind of index option is DataCompression.

DropExisting

The kind of index option is DropExisting.

FileStreamOn

The kind of index option is FileStreamOn.

FillFactor

The kind of index option is FillFactor.

IgnoreDupKey

The kind of index option is IgnoreDupKey.

LobCompaction

The kind of index option is LobCompaction.

MaxDop

The kind of index option is MaxDop.

MoveTo

The kind of index option is MoveTo.

Online

The kind of index option is Online.

PadIndex

The kind of index option is PadIndex.

SortInTempDB

The kind of index option is SortInTempDB.

StatisticsIncremental

The kind of index option is StatisticsIncremental.

StatisticsNoRecompute

The kind of index option is StatisticsNoRecompute.

Return to top
Show: