How can I drop multiple columns from a table in a single command
Oracle says there is a 'continue' option in 'Alter tabledrop column '
But I don't know how to use that option . I am trying various combinations but it's not working.
Amol
Printable View
How can I drop multiple columns from a table in a single command
Oracle says there is a 'continue' option in 'Alter tabledrop column '
But I don't know how to use that option . I am trying various combinations but it's not working.
Amol
"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 :-)
ALTER TABLE tablename DROP ( column1, column2, ... ) might be what your looking for.
Andy
ALTER TABLE table_name SET UNUSED (column_name1, column_name2);
ALTER TABLE table_name DROP UNUSED COLUMNS;