Re: Deleting columns in Oracle 7

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)

Catherine's Reply:
You cannot delet a column from a table in Oracle (you can add a column or enlarge one but not delete one).

My solution has been create a temporary table using the "create table" with an "as select query":

e.g. create table temporary(field1, field2, field3...)

     as select field1,field2,field3..
	from original_table_name

then drop the original table and rename the temporary table.

Catherine in Ottawa, Canada :~) Received on Thu Dec 10 1998 - 17:51:16 CET