Export (0) Print
Expand All

TableHintKind Enumeration

 

Applies To: SQL Server 2016 Preview

Represents the types of table hint.

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

[SerializableAttribute]
public enum class TableHintKind

Member nameDescription
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.

Snapshot

The hint is Snapshot.

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.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft