TableHintKind Enumeration

Represents the types of table hint.

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Enumeration TableHintKind
'Usage
Dim instance As TableHintKind

[SerializableAttribute]
public enum TableHintKind

[SerializableAttribute]
public enum class TableHintKind

[<SerializableAttribute>]
type TableHintKind

public enum TableHintKind

	Member name	Description
	FastFirstRow	The hint is FastFirstRow.
	ForceScan	The FORCESCAN keyword.
	ForceSeek	The hint is ForceSeek.
	HoldLock	The hint is HoldLock.
	IgnoreConstraints	The hint is IgnoreConstraints.
	IgnoreTriggers	The hint is IgnoreTriggers.
	Index	The hint is Index.
	KeepDefaults	The hint is KeepDefaults.
	KeepIdentity	The hint is KeepIdentity.
	NoExpand	The hint is NoExpand.
	NoLock	The hint is NoLock.
	None	The hint is None.
	NoWait	The hint is NoWait.
	PagLock	The hint is PagLock.
	ReadCommitted	The hint is ReadCommitted.
	ReadCommittedLock	The hint is ReadCommittedLock.
	ReadPast	The hint is ReadPast.
	ReadUncommitted	The hint is ReadUncommitted.
	RepeatableRead	The hint is RepeatableRead.
	Rowlock	The hint is Rowlock.
	Serializable	The hint is Serializable.
	SpatialWindowMaxCells	The hint is SpatialWindowMaxCells.
	TabLock	The hint is TabLock.
	TabLockX	The hint is TabLockX.
	UpdLock	The hint is UpdLock.
	XLock	The hint is Xlock.