Re: Deleting a column from table

No, you can't drop or rename a column in Oracle. But there are some tools which will do all the work (create a new table, copy the data, create the indexes, foreign keys ...) for you. Look at ftp:\\www.keeptool.com. You can download a free trial version of the Oracle tool Hora 3.

regards Jan.Dieckmann

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 Mon Nov 09 1998 - 07:26:16 CST