Re: Changing a column

I have used S-Designor to drop and recreate. It's pretty nice because it creates the temp tables to hold your data and then puts it back into the new table structure. Obviously a few issues to work out as far as the placement of the new column. Yes, it does drop all of your constraints and privileges.

To modify my test tables I have used the database painter in PowerBuilder. I can't remember exactly how to do it but I know it has to do with the Pipeline feature. In this case, you lose all your data also.

Good Luck

"Sbaiz" <pierluigi.sbaiz_at_elsag.it> wrote:

>Hi to all
>is there a way, in Oracle, to modifiy a column name without dropping the
>table
>maintaining its data. I know that others databases permit changing the name
>of
>the column or dropping a column, but Oracle not.
>It would be nice if Oracle can modify the column name or generate the
>scripts
>by itself, taking care of all the constraints.
>
>Thanks in advance.
>Pierluigi S.
Received on Tue Apr 21 1998 - 20:32:24 CDT