From: "Dante A. Notari-Locher" <dnotari@cso.at>
Subject: Re: rename a column?
Date: 1997/09/09
Message-ID: <34158784.26937096@cso.at>#1/1
References: <340F5973.41C6@dreamworks.com> <340fbbbc.490920@69.0.9.9>
To: Tim Hall <tim.hall@tswi.com>
Organization: CSO.Net Telecom Services, http://www.cso.net
Newsgroups: comp.databases.oracle.misc



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]