Re: deleting oracle table field???

From: Rozi & George Goldberger <ghita_at_worldnet.att.net>
Date: Wed, 28 Feb 2001 19:43:48 GMT
Message-ID: <Uxcn6.55$Ry6.71855@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 Wed Feb 28 2001 - 13:43:48 CST