Lock Mode
Lock Mode Abbrev-
iation
Code Description
Schema-Stability Sch-S 2 Used when compiling queries
Schema Modification Sch-M 3 Used when a table data definition language operation
(e.g. dropping a table) is being performed
Shared S 4 Used for reading
Update U 5 Used to evaluate prior to writing
Exclusive X 6 Used for writing
Intent Shared IS 7 Have or will request shared lock(s) at a finer level
Intent Update IU 8 Have or will request update lock(s) at a finer level
Intent Exclusive IX 9 Have or will request exclusive lock(s) at a finer level
Shared Intent Update SIU 10 Have shared lock with intention to acquire update lock
at a finer level
Shared Intent Exclusive SIX 11 Have shared lock with intention to acquire exclusive
lock at a finer level
Update Intent Exclusive UIX 12 Have update lock with intention to acquire exclusive
lock at a finer level
Bulk Update BU 13 Used when bulk copying data into a table and either
TABLOCK hint is specified or the table lock on bulk
load table option is set