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

Members

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.

See Also

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace