IndexOptionKind Enumeration
Specifies the possible index options.
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)
| Member name | Description | |
|---|---|---|
| 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. |
Show: