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.
"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 :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
ALTER TABLE tablename DROP ( column1, column2, ... ) might be what your looking for.
ALTER TABLE table_name SET UNUSED (column_name1, column_name2);
ALTER TABLE table_name DROP UNUSED COLUMNS;
Click Here to Expand Forum to Full Width