Re: dropping a column

You cannot drop a column from a table directly in Oracle. You can add a column
and change its datatype and field size as long as its larger but you cannot decrease
the size of a field or the table itself. You will have to create a separate table with
the fields and sizes you do want and then load your data into this table. This
will allow you to reposition the columns and drop the column.

Kathie

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
>
>
>
Received on Thu Jul 31 1997 - 00:00:00 CEST