title: Copy table structure and change one column name
body: <p>I am given the following table:</p>
  
  <p>Students</p>
  
  <ul>
  <li>Student_ID VARCHAR(50) PRIMARY KEY</li>
  <li>Name VARCHAR(50)</li>
  <li>Adres VARCHAR(150)</li>
  </ul>
  
  <p>Now I want to copy the tables structure, but change <code>Student_ID</code> to <code>Teacher_ID</code>.</p>
  
  <p>The teachers table should look like this:</p>
  
  <ul>
  <li>Teacher_ID VARCHAR(50) PRIMARY KEY</li>
  <li>Name VARCHAR(50)</li>
  <li>Adres VARCHAR(150)</li>
  </ul>
  
  <p>So far I have this line of code:</p>
  
  <pre><code>CREATE TABLE Teachers LIKE Students
  </code></pre>