sql - 在 Oracle 中删除多个列

Question

是否可以使用单个查询删除 oracle 10g 中的多个列？

Answer 1

这个怎么样？

Physical Delete

To physically drop a column you can use one of the following syntaxes, depending on whether you wish to drop a single or multiple columns.

ALTER TABLE table_name DROP COLUMN column_name; --drop SINGLE column

ALTER TABLE table_name DROP (column_name1, column_name2); --drop MANY columns

Source

alter table
       table_name
    drop
       (col_name1, col_name2);  -- drop MANY columns