TableHintKind Enum

Definition

Namespace:

Microsoft.SqlServer.TransactSql.ScriptDom

Assembly:

Microsoft.SqlServer.TransactSql.ScriptDom.dll

Package:

Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

The table hints.

[System.Serializable]
public enum TableHintKind

[<System.Serializable>]
type TableHintKind = 

Public Enum TableHintKind

Inheritance

Enum

TableHintKind

Attributes

SerializableAttribute

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