Dr. Jan Dieckmann wrote:
>
> 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.
Oracle 8.1 (or 8i) will be able to drop columns
--
Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"
Received on Fri Nov 13 1998 - 01:43:58 CST
