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
FastFirstRow | 1 | FASTFIRSTROW keyword. |
ForceScan | 25 | FORCESCAN keyword. |
ForceSeek | 22 | FORCESEEK keyword. |
HoldLock | 2 | HOLDLOCK keyword. |
IgnoreConstraints | 20 | IGNORE_CONSTRAINTS keyword. |
IgnoreTriggers | 21 | IGNORE_TRIGGERS keyword. |
Index | 23 | INDEX table hint |
KeepDefaults | 19 | KEEPDEFAULTS keyword. |
KeepIdentity | 18 | KEEPIDENTITY keyword. |
NoExpand | 15 | NOEXPAND keyword. |
NoLock | 3 | NOLOCK keyword. |
None | 0 | Nothing was used. |
NoWait | 16 | NOWAIT keyword. |
PagLock | 4 | PAGLOCK keyword. |
ReadCommitted | 5 | READCOMMITTED keyword. |
ReadCommittedLock | 17 | READCOMMITTEDLOCK keyword. |
ReadPast | 6 | READPAST keyword. |
ReadUncommitted | 7 | READUNCOMMITTED keyword. |
RepeatableRead | 8 | REPEATABLEREAD keyword. |
Rowlock | 9 | ROWLOCK keyword. |
Serializable | 10 | SERIALIZABLE keyword. |
Snapshot | 26 | SNAPSHOT keyword |
SpatialWindowMaxCells | 24 | SPATIAL_WINDOW_MAX_CELLS table hint |
TabLock | 11 | TABLOCK keyword. |
TabLockX | 12 | TABLOCKX keyword. |
UpdLock | 13 | UPDLOCK keyword. |
XLock | 14 | XLOCK keyword. |