title: Are schema modifying commands transactional?
body: <p>For example, if I drop a table then roll back the transaction is the table recreated?</p>
  
  <p>What are the limits to the schema changes that can be made in a transaction?</p>
  
  <p>If the above depends on the version of Sql Server, please say so...</p>
  
  <p><strong>Background</strong><br>
  I am thinking of using some “select into” statements to create tables and then need to drop ALL the above tables as a later part of the workflow.</p>
  
  <p>None of the table will have more then a few tens of rows.</p>