Schema Lock Sufficiency

A sufficiency matrix table for schema locks.

  Is That Lock Sufficient if the Task Needs:
Lock Type Held: An Exclusive Schema Lock? A Shared Schema Lock?
An exclusive schema lock Yes Yes
A shared schema lock No Yes
Parent topic: Lock Compatibility and Lock Sufficiency