Re: Renaming a column

From: Andy Hardy <Andy.Hardy_at_camk.demon.co.uk>
Date: 1999/02/02
Message-ID: <GpXGNHAzhst2Mw6a@camk.demon.co.uk>#1/1

In article <78meok$biv$1_at_nnrp1.dejanews.com>, bastien.piroue_at_gsioffice. 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

Received on Tue Feb 02 1999 - 00:00:00 CST