I recently went through a book about locks ,i have a question in it ,so i request you to kindly clarify my question.
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 question .
Thanks And Regards