Re: Renaming a column

From: Tibor Karaszi <tibor_at_cornerstone.se>
Date: 1999/01/27
Message-ID: <enrNaicS#GA.222@uppssnewspub04.moswest.msn.net>#1/1

Bastien,

I cannot speak for Oracle.
SQL Server 6.5 do not allow you to change these attributes. SQL Server 7.0 does.

One too that might help is Visual Database Tools (shipped with Visual Studio, etc). It will copy the data to temptable etc, so be aware if you have a lot of data. It might even work for Oracle (don't know about that).

--
Tibor Karaszi
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please do not respond by e-mail unless explicitly asked for.

bastien.piroue_at_gsi-office.de wrote in message
<78meok$biv$1_at_nnrp1.dejanews.com>...


>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?

>

>Thank you for any help!

>

>Bastien Piroué, Germany

>

>-----------== Posted via Deja News, The Discussion Network ==----------

>http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Wed Jan 27 1999 - 00:00:00 CST