Schema Lock Compatibility

A summarized table about schema lock compatibility, showing when locks can be acquired immediately.

  Can Another Process Acquire:
Lock Type Held: An Exclusive Schema Lock? A Shared Schema Lock?
An exclusive schema lock No No
A shared schema lock No Yes