From: Eric & Carole Kamradt <kamradt@inconnect.com>
Subject: Re: How to remove a column
Date: 1997/08/08
Message-ID: <33EB0F1D.EF694B3A@inconnect.com>#1/1
References: <01bca30f$c7f1c9c0$2bf2bb81@maus> <33EA46BD.1257@ibm.net>
To: hmonka@ibm.net
X-Priority: 3 (Normal)
Organization: Internet Connect, Inc. -- http://www.inconnect.com	
Newsgroups: comp.databases.oracle.server



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@inconnect.com
http://www.inconnect.com/~kamradt/resume.html