Re: Wherefore art thee: "Drop Column"?
From: Jim Gregory <jim.gregory_at_daytonoh.ncr.com>
Date: 1996/02/01
Message-ID: <DM46r7.Lp7_at_intruder.daytonoh.attgis.com>#1/1
Date: 1996/02/01
Message-ID: <DM46r7.Lp7_at_intruder.daytonoh.attgis.com>#1/1
create new_table < col list less col you want to drop > as select < list of colums >
verify table is ok
drop old_table
rename new_table to old_table
HTH
Jim Gregory
>==========Lane Sharman, 1/31/96==========
>
>Is it really true that Oracle 7.1.3 does not support the drop column
>function within the alter table.
>
>If not is there a work-around?
>
>
The opinions expressed are my own and do not reflect those of my employer or clients. Received on Thu Feb 01 1996 - 00:00:00 CET