Re: fix table. HOW TO?

From: Filip Hanik <fhanik_at_digitalworkforce.net>
Date: Wed, 7 Jul 1999 12:48:49 -0700
Message-ID: <L8Og3.535$W71.28476@typhoon-sf.snfc21.pbi.net>

You cant delete columns or rename them in Oracle. I think it is fixed in Oracle 8i.

If you use some sort of modeling tool, like Erwin, the usually will generate a script to recreate the table and all its dependencies.

Filip

Vadim Grepan <kezal_at_mail.ru> wrote in message news:7lvfop$ltb$1_at_storm.comstar.ru...
> Hello All!
>
> I've in my table (record) some fields, which I want to delete. I know
how
> update fields (e.g. increse or change type), but I don't know how delete
> they permanent, with useless data?
>
> Rgds, Vadim Grepan
> --------
> kezal_at_mail.ru
> 2:5020/653_at_fidonet.org
>
>
>
Received on Wed Jul 07 1999 - 14:48:49 CDT