title: How do you ADD and DROP columns in a single ALTER TABLE
body: <p>I tried the following but I got a syntax error</p>
  
  <pre><code>ALTER TABLE Grades ( 
  DROP COLUMN (Student_FamilyName, Student_Name),
  ADD Student_id INT );
  </code></pre>
  
  <p>Is it possible to perform a <code>DROP</code> and an <code>ADD</code> in the same <code>ALTER TABLE</code> statement?</p>