title: How to create a new table based on fields from an existing table using SQL-Server?
body: <p>I Just want to know how to create a new table based on an existing table column:</p>
  
  <pre><code>Current Table name : EmployeeDetails
  Columns: empName, Address, pincode, state, city
  Primary key is : pincode
  </code></pre>
  
  <p>I want to create the new table from EmployeeDetails:</p>
  
  <pre><code>New Table name : Information
  column :pincode, state, city ---&gt; from EmployeeDetails table
  </code></pre>