Re: deleting oracle table field???

From: Nicholas Mudie <nmudie_at_chello.com>
Date: Thu, 01 Mar 2001 08:29:14 GMT
Message-ID: <uLnn6.7672$Ed3.1347131@amsnews02.chello.com>

THANKS EVERYONE, THIS HAS SOLVED ALL MY PROBLEMS :o)

"Rozi & George Goldberger" <ghita_at_worldnet.att.net> wrote in message news:Uxcn6.55$Ry6.71855_at_typhoon2.ba-dsg.net...
> A better way to drop a column from a production database is:
>
> ALTER TABLE<name> SET UNUSED column <col1>, col2>,...;
>
> This will not impediment the use of the table
>
> At the end of the day:
>
> ALTER TABLE <name> DROP UNUSED;
>
> George
>
>
> "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 Thu Mar 01 2001 - 02:29:14 CST