title: How do I create a table based on another table
body: <p>I want to create a table based on the definition of another table.</p>
  
  <p>I'm coming from oracle and I'd normally do this:</p>
  
  <pre><code> CREATE TABLE schema.newtable AS SELECT * FROM schema.oldtable;
  </code></pre>
  
  <p>I can't seem to be able to do this in SQL Server 2008.</p>