sys.sp_indexoption

Description

Sets locking option values for user-defined clustered and nonclustered indexes or tables with The SQL Server Database Engine automatically makes choices of page-, row-, or table-level locking. You don’t have to set these options manually. users who know with certainty that a particular type of lock is always appropriate. The qualified or nonqualified name of a user-defined table or index.

Syntax

sp_indexoption
[ @
I ndex
N ame
P attern = ]
N
'IndexNamePattern'
, [ @
O ption
N ame = ]
'OptionName'
, [ @
O ption
V alue = ]
'OptionValue'
[ ; ]