On Tue, Feb 22, 2000 at 08:23:17PM -0500, Bruce Momjian wrote:
> > Dear Mr Momjian
> >
> > Just a quick suggestion for an added feature: "DROP COLUMN columnname
> > FROM table..." and "ALTER COLUMN columname FROM table..." queries would
> > spare my hair when I make mistakes in table creation.
>
> We have the DROP, but will not appear in 7.0.
One last little note on the whole DROP COLUMN discussion:
A snip from Phil Greenspun's photo.net site:
"Adding a column to a relational database table seldom breaks
queries. Until Oracle 8.1.5, you weren't able to drop a column."
My guess would be that Oracle found out internally what we've been
discussing here: doing DROP COLUMN right is _hard_.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005