TableHintKind Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The table hints.
[System.Serializable]
public enum TableHintKind[<System.Serializable>]
type TableHintKind = Public Enum TableHintKind- Inheritance
-
TableHintKind
- Attributes
Fields
| Name | Value | Description |
|---|---|---|
| None | 0 | Nothing was used. |
| FastFirstRow | 1 | FASTFIRSTROW keyword. |
| HoldLock | 2 | HOLDLOCK keyword. |
| NoLock | 3 | NOLOCK keyword. |
| PagLock | 4 | PAGLOCK keyword. |
| ReadCommitted | 5 | READCOMMITTED keyword. |
| ReadPast | 6 | READPAST keyword. |
| ReadUncommitted | 7 | READUNCOMMITTED keyword. |
| RepeatableRead | 8 | REPEATABLEREAD keyword. |
| Rowlock | 9 | ROWLOCK keyword. |
| Serializable | 10 | SERIALIZABLE keyword. |
| TabLock | 11 | TABLOCK keyword. |
| TabLockX | 12 | TABLOCKX keyword. |
| UpdLock | 13 | UPDLOCK keyword. |
| XLock | 14 | XLOCK keyword. |
| NoExpand | 15 | NOEXPAND keyword. |
| NoWait | 16 | NOWAIT keyword. |
| ReadCommittedLock | 17 | READCOMMITTEDLOCK keyword. |
| KeepIdentity | 18 | KEEPIDENTITY keyword. |
| KeepDefaults | 19 | KEEPDEFAULTS keyword. |
| IgnoreConstraints | 20 | IGNORE_CONSTRAINTS keyword. |
| IgnoreTriggers | 21 | IGNORE_TRIGGERS keyword. |
| ForceSeek | 22 | FORCESEEK keyword. |
| Index | 23 | INDEX table hint |
| SpatialWindowMaxCells | 24 | SPATIAL_WINDOW_MAX_CELLS table hint |
| ForceScan | 25 | FORCESCAN keyword. |
| Snapshot | 26 | SNAPSHOT keyword |