Add/Delete multiple columns in a single alter statement

by Ramya 2008-11-11 09:38:48

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;

Tagged in:

835
like
1
dislike
0
mail
flag

You must LOGIN to add comments