dropping multiple columns from a single command

[amolik]

How can I drop multiple columns from a table in a single command

Oracle says there is a 'continue' option in 'Alter table drop column '
But I don't know how to use that option . I am trying various combinations but it's not working.

Amol

[julian]

"ALTER TABLE DROP COLUMNS CONTINUE" is used to complete dropping the column before accessing the table.

I really don't know if you can drop 2 columns at the same time. It is really not that important feature. Run the command two times and you will drop the columns :-)

[AndyEPS]

ALTER TABLE tablename DROP ( column1, column2, ... ) might be what your looking for.

Andy

[akshayvashisth]

ALTER TABLE table_name SET UNUSED (column_name1, column_name2);

ALTER TABLE table_name DROP UNUSED COLUMNS;