Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rename a column?
Hi Tim,
I am evaluation at this moment DB Artisan 3.0 (www.embarcadero.com) With this tool you can rename columns (it recreates the table for you). Regards Dante A. Notari-Locher
Tim Hall wrote:
>
[snip]
>
> >Is there any way to rename a column, other than recreating the table?
> >
> >The ALTER TABLE command allows you to change constraints and
> >data types on a column, but doesn't seem to allow a name change.
> >
[snip]
> No, you can't. The only way is to recreate the table, as you feared.
> This is a real pain.
> ----------------------------------------------------
> Tim Hall, TSW International, Now Indus International
>
[snap]
Received on Tue Sep 09 1997 - 00:00:00 CDT