Drop/Remove Column in Oracle Table

Here’s a quick post on how to drop a column/field in a table.

Dropping One Column
alter table
table_name
drop column col_name1;

Dropping Multiple Columns

alter table
table_name
drop (col_name1, col_name2);

Simple, eh?