Re: SQL Help - removing a column

You've been told correctly - Columns may be modified and added but not removed. A contributor to this group is working on a 'work-around' that will allow this, but I've lost track of that thread.

John Greco
Oracle DBA ( 7.3, Netware 4.11)
Reply to john.greco_at_dot.state.mn.us

Trien Ngoc Nguyen <trien_at_purdue.edu> wrote:

>I've been told that there is no "clean" way to remove a
>column from a pre-existing table.
>I know it's possible to add and modify columns in SQL*Plus,
>but is there a way to remove a column.
>
>
>Thank you,
>
>trien
Received on Fri Oct 31 1997 - 00:00:00 CST