Re: Deleting columns from a table

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.
Received on Fri Nov 06 1998 - 19:48:44 CST