DML Locks and DDL Locks Clarification
878644Mar 27 2012 — edited Mar 27 2012Hello All,
I recently went through a book about locks ,i have a doubt it that ,so i request you to kindly clarify my doubt.
DOUBT
=====
As per the book , When a DML operation is done an automatic DDL lock is placed in the table . So to test this i created a table insert some rows ,commited and once again i updated the table at this point of time i did not commit the work (so the transaction is not completed) and issued a DDL (drop table) the table was droped . I dont understand why this happend ,Please clarify my doubt .
Thanks And Regards .