Re: Deleting columns in Oracle 7

From: David Lane <dlane_at_cix.compulink.co.uk>
Date: Sat, 12 Dec 1998 20:18:35 GMT
Message-ID: <F3vCEz.FIB_at_cix.compulink.co.uk>


In article <366FE18B.21AD852A_at_cms.dalford.ac.uk>, j.g.jones_at_cms.dalford.ac.uk (Jospeh G. Jones) wrote:

> Can anyione help please. I cannot find the SQL syntax for removing a
> column from a table in Oracle.
>
> Thanks
>
> Joe Jones (j.g.jones_at_cms.salford.ac.uk)
>
>

It's not possible to drop a column in Oracle .... only to add them. You would have to create a new table:-
create table temp_name storage (....)
as select col1,col2,col4 from old_table; then:-
drop table old_table;
rename temp_name to old_table;

Dave Lane (dlane_at_pt.lu) Received on Sat Dec 12 1998 - 21:18:35 CET

Original text of this message