title: How to create a new table from an existing table?
body: <pre><code>dbo.Profile_Updated
    (
       BusinessName VARCHAR,
       ContactName  VARCHAR,
       Address      VARCHAR,
       City         VARCHAR,
       State        VARCHAR,
       Postalcode   INT PRIMARY KEY,
       Phonenumber  VARCHAR
    ) 
  </code></pre>
  
  <p>This is my current table but now I want to create new table from the existing <code>Profile_Updated</code> table column, I mean the new table (<code>PostalDB</code>) needs to contain the columns <code>City, State, Postalcode</code> based on <code>Profile_Updated</code> table.</p>
  
  <p>Can anyone help me?</p>
  
  <p>Thanks in advance.</p>