Add/Delete multiple columns in a single alter statement

Add / Delete Multiple columns in a single statement

You can use multiple ADD, DROP clauses in a single ALTER statement, separated by commas.

Add multiple columns in a single alter statement

    ALTER TABLE t2 ADD COLUMN c, ADD COLUMN d;

Delete multiple columns in a single alter statement

    ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d;