Re: Delete a column from a table ?

From: Irene Westervelt <iwesterv-no_at_span.mdsi.bc.ca>
Date: 1998/03/13
Message-ID: <01bd4ec1$afd88820$a913f28a@pc354>#1/1

Make a copy of this table: create table b as select * from table a; Drop and recreate table a excluding the column you do not want. insert into new table (col1,col2,col...) exclude the one you do not want select col1,col2,col3
from b;

Marco Nedermeijer <m.n.nedermeijer_at_rtd.nl> wrote in article <6e8t85$iru$1_at_news.NL.net>...
> This may sound stupid, but how can a delete a column from a table ?
>
> Thanks,
>
> Marco Nedermeijer
> m.n.nedermeijer_at_rtd.nl
>
>
>
Received on Fri Mar 13 1998 - 00:00:00 CST