Re: deleting oracle table field???

From: Andrew Velichko <andrew_velichko_at_yahoo.com>
Date: Wed, 28 Feb 2001 11:59:44 -0500
Message-ID: <Mban6.135204$Z2.1822354@nnrp1.uunet.ca>

Hi Nick!

create table tmp1 (f1 number, f2 number); alter table tmp1 drop column f1;
work fine in Oracle8i.

In previous versions you should recreate, I think.

Andrew Velichko
Brainbench MVP for Oracle Developer 2000 http://www.brainbench.com

"Nicholas Mudie" <nmudie_at_chello.com> wrote in message news:9m9n6.6832$Ed3.1246962_at_amsnews02.chello.com...
> how do I delete a field from an Oracle table..do I have to re-create???
>
> Thanks,
> Nick
>
>
Received on Wed Feb 28 2001 - 10:59:44 CST