Re: dropping a column

Hi Ceri,

I cannot think of any reason why you would care for sequence of columns in a relational db tables. However, if you have to do it then simplest solution is rename that table to different name and define view on that table with proper sequence of columns.

Second alternative is to drop and recreate table with new sequence.

Ceri Moran wrote:
>
> 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 Wed Jul 09 1997 - 00:00:00 CDT