Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: rename a column?

Re: rename a column?

From: Dante A. Notari-Locher <dnotari_at_cso.at>
Date: 1997/09/09
Message-ID: <34158784.26937096@cso.at>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US