Re: Changing column name in oracle?

From: Holger Heidenbluth <heidenbluth_at_nis-rheinsberg.de>
Date: 2000/06/16
Message-ID: <8idcn8$2j6$1@wrath.news.nacamar.de>#1/1

KeepTool (www.keeptool.com) generates/executes a script to rename or drop a column. It works fine from 7.3 up to 8i. Right click column and "rename".

Regards
Holger

Sunny <sunnyb_at_vendtek.bc.ca> schrieb in im Newsbeitrag: 8i3o8a$rtd$1_at_newsfeed.smartt.com...
> Hi everyone
>
> is it possible to change a table's column name to something else along
with
> the definition. I know the definition can be changed with the alter
> statement but is it possible to change the columns name, for example
>
> table test has
>
> test_id Comments
>
> fields can i change test_id to test_Number.
>
> please let me know thanks
>
>
Received on Fri Jun 16 2000 - 00:00:00 CDT