Re: Dropping a field from a table

In oracle 8.3 it is possible to delete a column i beleive. However if you are useing oracle 7.3 the only way you can delete a column is

1)create another table say x1 excluding the column
2) drop the current table.
3) rename x1 to current.

Colin Basterfield wrote:

> Hello,
>
> Perhaps a stupid question, but i can't find anywhere how to delete a
> field from a table. Is it possible?
>
> TIA
> Colin B
Received on Fri May 07 1999 - 09:32:14 CDT