Re: Deleting a column from table

Hi Kiran,

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

kiran cherukuri wrote:

> Hi all,
>
> I'm wondering whether or not it is possible to delete a column from
> the table once the
> table was create ? I don't want to drop the table and recreate it, I
> just want to delete an
> unnecessary column/field from the table. Thanks in advance.
>
> Kiran.
Received on Fri Nov 06 1998 - 19:43:27 CST