Re: dropping a column

Ceri Moran <ceri_at_n-ary.com> wrote in article <33c25611.15618838_at_clientnews.wisper.net>...
> Hi,
>
> I know this may seem a stupid question, but I am using Oracle 7.3 for
> NT, and I am having dificulty altering the table.
>
> I have two columns in the middle of a table, I wish to move to the
> end, I cant seem to reorder using the Navigator or SQLPLUS.
>
> I have tried removing and adding them in, but cant seem to find the
> correct SQL to allow me to do this.
>
> Please could you advise me the correct SQL for dropping a non-key
> column from a table?
>
> Thanks
>
> Ceri Moran
>
>
>
Hi Ceri

  There is no way in Oracle7 to drop a column in a table.   You have to recreate the table.  

Tiago Pinheiro     Received on Wed Jul 09 1997 - 00:00:00 CEST