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 '('.

Accepted Answer

```
ALTER TABLE TableToDropColumn DROP COLUMN Field2, Field3
```

SQLFiddle demo

Drop Multiple Column Using single Alter

Solution

Problem