TableHintKind TableHintKind TableHintKind Enum

Definition

The table hints.

[Serializable]
public enum TableHintKind
type TableHintKind = 
Public Enum TableHintKind
Inheritance
TableHintKindTableHintKindTableHintKind
Attributes
SerializableAttribute

Fields

FastFirstRow FastFirstRow FastFirstRow 1

FASTFIRSTROW keyword.

ForceScan ForceScan ForceScan 25

FORCESCAN keyword.

ForceSeek ForceSeek ForceSeek 22

FORCESEEK keyword.

HoldLock HoldLock HoldLock 2

HOLDLOCK keyword.

IgnoreConstraints IgnoreConstraints IgnoreConstraints 20

IGNORE_CONSTRAINTS keyword.

IgnoreTriggers IgnoreTriggers IgnoreTriggers 21

IGNORE_TRIGGERS keyword.

Index Index Index 23

INDEX table hint

KeepDefaults KeepDefaults KeepDefaults 19

KEEPDEFAULTS keyword.

KeepIdentity KeepIdentity KeepIdentity 18

KEEPIDENTITY keyword.

NoExpand NoExpand NoExpand 15

NOEXPAND keyword.

NoLock NoLock NoLock 3

NOLOCK keyword.

None None None 0

Nothing was used.

NoWait NoWait NoWait 16

NOWAIT keyword.

PagLock PagLock PagLock 4

PAGLOCK keyword.

ReadCommitted ReadCommitted ReadCommitted 5

READCOMMITTED keyword.

ReadCommittedLock ReadCommittedLock ReadCommittedLock 17

READCOMMITTEDLOCK keyword.

ReadPast ReadPast ReadPast 6

READPAST keyword.

ReadUncommitted ReadUncommitted ReadUncommitted 7

READUNCOMMITTED keyword.

RepeatableRead RepeatableRead RepeatableRead 8

REPEATABLEREAD keyword.

Rowlock Rowlock Rowlock 9

ROWLOCK keyword.

Serializable Serializable Serializable 10

SERIALIZABLE keyword.

Snapshot Snapshot Snapshot 26

SNAPSHOT keyword

SpatialWindowMaxCells SpatialWindowMaxCells SpatialWindowMaxCells 24

SPATIAL_WINDOW_MAX_CELLS table hint

TabLock TabLock TabLock 11

TABLOCK keyword.

TabLockX TabLockX TabLockX 12

TABLOCKX keyword.

UpdLock UpdLock UpdLock 13

UPDLOCK keyword.

XLock XLock XLock 14

XLOCK keyword.

Applies to