Export (0) Print
Expand All
Expand Minimize

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 IndexOptionKind

Member nameDescription
AllowPageLocksThe kind of index option is AllowPageLocks.
AllowRowLocksThe kind of index option is AllowRowLocks.
BucketCountThe kind of index option is BucketCount.
DataCompressionThe kind of index option is DataCompression.
DropExistingThe kind of index option is DropExisting.
FileStreamOnThe kind of index option is FileStreamOn.
FillFactorThe kind of index option is FillFactor.
IgnoreDupKeyThe kind of index option is IgnoreDupKey.
LobCompactionThe kind of index option is LobCompaction.
MaxDopThe kind of index option is MaxDop.
MoveToThe kind of index option is MoveTo.
OnlineThe kind of index option is Online.
PadIndexThe kind of index option is PadIndex.
SortInTempDBThe kind of index option is SortInTempDB.
StatisticsIncremental
StatisticsNoRecomputeThe kind of index option is StatisticsNoRecompute.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft