Re: Deleting columns from a table

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Mon, 09 Nov 1998 14:11:35 +0100
Message-ID: <3646EA07.A14E1532@psi.de>

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

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 Mon Nov 09 1998 - 07:11:35 CST