Drop Multiple Column Using single Alter

Question

I searched a lot on web, but couldn't find the answer for dropping multiple columns in single alter statement using SQL Server 2008.

I tried following query

ALTER TABLE TableToDropColumn DROP (Field2, Field3)

but it throws an error

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '('.

Answer 1

ALTER TABLE TableToDropColumn DROP COLUMN Field2, Field3

SQLFiddle demo