Re: How to delete a column from a table?

Connor McDonald wrote:
>
> Simon Goland wrote:
> >
> > Yes, I know, I have seen it here sometime ago. But it was "then", and I
> > thought I won't need it... but now I do... ;-)
> >
> > So my long and tedious approach so far is:
> >
> > --
> > [ Simon Goland B-)> sg_at_mda.ca ]
> > [ Without action there is no change ]
>
> Cheap and easy way...but not really doing the drop...
>
> rename table xxx to xxx_gone
> create view xxx as select (* minus missing column) from xxx_gone...
>
> Voila ! (Ugh...)
>
> Cheers
> --
> Connor McDonald
> Systems Administrator-Unix/Oracle
> BHP Iron Ore
> "You're not drunk if you can lie on the floor without holding on"
> - Dean Martin

Shouldn't this read:

 rename table xxx to xxx_gone
 create table xxx as select (* minus missing column) from xxx_gone...

That is, the second line should be creating a table, not a view on the old table you want to get rid of?

Steve Phelan. Received on Mon Mar 10 1997 - 00:00:00 CST