title: SQL Server: Does 'DROP TABLE' inside transaction causes an implicit commit?
body: <p>My question is kind of easy but i'm still doubting after I created this transaction. If I execute the following code:</p>
  
  <pre><code>BEGIN TRANSACTION
        DROP TABLE Table_Name
  </code></pre>
  
  <p>Can I perform a ROLLBACK TRANSACTION that recovers the dropped table? I'm asking because I don't know what happens in the 'Object Explorer' and I didn't found any question of this topic, so I think that it could be a useful issue.</p>