Re: Why can we not delete columns in tables?

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/29
Message-ID: <01bccce6$7e405160$54110b87@clamagent>#1/1

Just the way it is.
But, you can create a new table by selecting just the columns you want (excluding the ones you don't want), drop the old table and rename the new one to the old one.
-djc

Tim Eyres <tim.eyres_at_genedata.com> wrote in article <342FC676.5DD9_at_genedata.com>...
> Does anybody know the justification for not being able to delete columns
> from tables when using Oracle? Is there a genuine relational database
> principle behind it or is it just an Oracle failing?
>
> Tim
>
Received on Mon Sep 29 1997 - 00:00:00 CDT