Re: Deleting columns from a table

One workaround is to:
1. rename the troublesome table,
2. create a view on that table with the old name, minus unwanted column.

Regards,
KL

In article <3643A732.BA8CDF25_at_usa.net>,   Madhu.Cherukuri_at_usa.net wrote:
>
> No, you can not drop a column
> from a table once it is created
> in Oracle. The only way you
> get rid of that is create a new
> table without the unwanted column
> and drop the old table and rename your
> new table to old table
>
> Madhu Cherukuri
>
> Prasanti Yalamanchili wrote:
>
> > Hi all,
> >
> > I'm wondering whether or not I can remove a column from the
> > table that was already created ? I don't want to drop the table and
> > recreate it, I just want to delete an unnecessary column/field from
> > the table/table definition.
> >
> > Thanks in advance
> > Prasanti.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 11 1998 - 13:36:04 CST