Re: Renaming a column

I believe that the only thing that this command will do is to create a second table that looks just like the first (names, datatypes, etc.) There is a tool that will allow you to do this - Desktop DBA from Platinum. However, you will need to have a Platinum card to get it, as it is fairly expensive. Jerry

"Christopher M. Day" wrote:

> Bastien,
>
> For Oracle you need to use 'CREATE TABLE AS SELECT' clause.
>
> Chris
>
> bastien.piroue_at_gsi-office.de wrote:
> >
> > 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