Re: How to delete a column from a table?

Connor McDonald wrote:
> 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...)

...OR...

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

JMHO
janet Received on Mon Mar 10 1997 - 00:00:00 CST