Re: Renaming a column

Andy Hardy wrote:
>
> In article <78meok$biv$1_at_nnrp1.dejanews.com>, bastien.piroue_at_gsi-
> office.de writes
> >Hello,
> >
> >I want
> >a) to change the datatype of a column of a table
> >b) to change the name of a column of a table.
> >
> >I want this for Oracle7, Oracle8 and MS-SQL-Server 6.5 and MS_SQL - Server 7.
> >The tables are in use, so that there are rows in it, that the alter table
> >alter column - command of ORACLE fails. Any tools, suggestions?
>
> Oracle fails because it does not have a rename column command. You'll
> need to drop and recreate, or possibley rename the old table and create
> a new view with the old tables name...
>
> Andy
> --
> Andy Hardy
> Senior IT Systems Engineer, Alstom Automation
> Tel: +44 1908 696200
> Fax: +44 1908 696225
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Opinions are mine and do not necessarily reflect those of Alstom Automation

You can also hack the COL$ table, but this is exceptionally NOT recommended!

Graham Received on Thu Feb 04 1999 - 00:00:00 CST