TableHintKind Enum

Definition

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.

Applies to