From: Andy Hardy Subject: Re: Renaming a column Date: 1999/02/02 Message-ID: #1/1 Distribution: world X-NNTP-Posting-Host: camk.demon.co.uk:194.222.188.130 References: <78meok$biv$1@nnrp1.dejanews.com> X-Complaints-To: abuse@demon.net X-Trace: news.demon.co.uk 917950468 nnrp-09:29592 NO-IDENT camk.demon.co.uk:194.222.188.130 Organization: Alstom Automation MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server,microsoft.public.sqlserver.server,comp.databases.ms-sqlserver In article <78meok$biv$1@nnrp1.dejanews.com>, bastien.piroue@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