Re: How can I drop a column from a table?
From: Frank Bommarito <75662.112_at_CompuServe.COM>
Date: 1996/08/01
Message-ID: <4tqa0m$dcu$1_at_mhafn.production.compuserve.com>#1/1
Date: 1996/08/01
Message-ID: <4tqa0m$dcu$1_at_mhafn.production.compuserve.com>#1/1
Exporting - Droping-creating without the column - importing will cause an Oracle error.
Easiest was is:
rename table_a to table_b;
create table_a as select all_wanted_columns from table_b;
drop table_b;
Note - indexes and the like must be handled seperately. Frank Received on Thu Aug 01 1996 - 00:00:00 CEST