For some operations, locks are hierarchical in nature -- for example for some partition operations, the table is also locked (to make sure that the table cannot be dropped while a new partition is being created). The rational behind the lock mode to acquire is as follows: For a non-partitioned table, the lock modes are pretty intuitive. When the table is being read, a S lock is acquired, whereas a