Export (0) Print
Expand All
Expand Minimize

TableHintKind Enumeration

SQL Server 2012

Represents the types of table hint.

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

public enum TableHintKind

Member nameDescription
FastFirstRowThe hint is FastFirstRow.
ForceScanThe FORCESCAN keyword.
ForceSeekThe hint is ForceSeek.
HoldLockThe hint is HoldLock.
IgnoreConstraintsThe hint is IgnoreConstraints.
IgnoreTriggersThe hint is IgnoreTriggers.
IndexThe hint is Index.
KeepDefaultsThe hint is KeepDefaults.
KeepIdentityThe hint is KeepIdentity.
NoExpandThe hint is NoExpand.
NoLockThe hint is NoLock.
NoneThe hint is None.
NoWaitThe hint is NoWait.
PagLockThe hint is PagLock.
ReadCommittedThe hint is ReadCommitted.
ReadCommittedLockThe hint is ReadCommittedLock.
ReadPastThe hint is ReadPast.
ReadUncommittedThe hint is ReadUncommitted.
RepeatableReadThe hint is RepeatableRead.
RowlockThe hint is Rowlock.
SerializableThe hint is Serializable.
SpatialWindowMaxCellsThe hint is SpatialWindowMaxCells.
TabLockThe hint is TabLock.
TabLockXThe hint is TabLockX.
UpdLockThe hint is UpdLock.
XLockThe hint is Xlock.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft