Re: How to remove a column

The easiest way to drop a column is to get a GUI tool like DBGeneral or ERWIN and let it worry about the constraints of dropping a column while you just tap the delete key.

Good luck
Eric Kamradt

Halina Monka wrote:

> Ingo Eichenseher wrote:
> >
> > Hi,
> >
> > What's an easy way to remove a column from
> > a table which already contains data?
> >
> > I'm using Oracle 7 Workgroup Server 7.3.2.2.1
> >
> > Thanks in advance
> >
> > Ingo Eichenseher
>
> Rename table.
> Create table as select columns you need from renamed table.
> Note that if you have views using dropped column, they will become
> invalid. The reason that Oracle does not give us nice "drop column"
> command is the validation which would have to follow:
> views,triggers,procedures...
> Personally, I would NULL column rather then drop it.
> Halina

--
Thanks for your time

Eric Kamradt
hm: (801) 567-0912
mailto: kamradt_at_inconnect.com
http://www.inconnect.com/~kamradt/resume.html