title: How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
body: <p>I would like to write a single SQL command to drop multiple columns from a single table in one <code>ALTER TABLE</code> statement.</p>
  
  <p>From <a href="http://msdn.microsoft.com/en-us/library/aa275462%28v=sql.80%29.aspx" rel="noreferrer">MSDN's ALTER TABLE documentation</a>...</p>
  
  <blockquote>
  <pre><code>DROP { [CONSTRAINT] constraint_name | COLUMN column_name }
  </code></pre>
    
    <p>Specifies that constraint_name or column_name is removed from the table. DROP COLUMN is not allowed if the compatibility level is 65 or earlier. Multiple columns and constraints can be listed.</p>
  </blockquote>
  
  <p>It says that mutliple columns can be listed in the the statement but the syntax doesn't show an optional comma or anything that would even hint at the syntax.</p>
  
  <p>How should I write my SQL to drop multiple columns in one statement (if possible)?</p>