Hi All,
Here is the scenario, there are Parent and child table say Purchase_master and tmp_Purchase_info respectively.
In a procedure(p1) i am dropping the child table "tmp_Purchase_info", simultenously there is an another procedure(p2) which is looking up some records from parent table "Purchase_master".
Purchase_Master holds the Sch-S lock since its getting used in proc (P2).
Now my question is while dropping child table will that cause Sch-M lock on parent table?
Thanks in Advance!