title: How to split table into multiple tables using SQL
body: <p>Hi I have this table Cars:</p>
  
  <pre><code>MODEL nvarchar(20)
  STYLE nvarchar(20)
  ENGINE nvarchar(5)
  CAPACITY smallint
  MAX_SPEED smallint
  PRICE smallmoney
  MARKET nvarchar(20)
  COMPETITOR nvarchar(20)
  </code></pre>
  
  <p>And I would like to split it into 3 tables via SQL query:</p>
  
  <p>Cars:</p>
  
  <pre><code>MODEL nvarchar(20)
  STYLE nvarchar(20)
  MAX_SPEED smallint
  PRICE smallmoney
  </code></pre>
  
  <p>Engine:</p>
  
  <pre><code>ENGINE nvarchar(5)
  CAPACITY smallint
  </code></pre>
  
  <p>Market:</p>
  
  <pre><code>MARKET nvarchar(20)
  COMPETITOR nvarchar(20)
  </code></pre>
  
  <p>So was wandering how this would be done using sql commands, thanks</p>