In one ALTER TABLE statement, I would like to construct a single SQL query to remove several columns from a single table.
From MSDN's ALTER TABLE documentation...
DROP { [CONSTRAINT] constraint_name | COLUMN column_name }
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.
Although it states that a statement may list many columns, the syntax doesn't even hint at the existence of an optional comma.
If possible, what syntax should I use to drop numerous columns at once in my SQL statement?