Re: R: [beginner] Changing column name and type without losing content

No, but adding a new and dropping the old would result in the same. Why change the name of a column anyway?

Francesco Marchioni wrote:

> Hello,
> thanks for your suggestion...anyway I needed one more step,
> that is changing column name too....is it possible to do it ?
> Thanks
> Francesco
>
> frank <fbortel_at_home.nl> wrote in message 39F87693.BB2966C5_at_home.nl...
> > SQL> create table lazy( fr number(2));
> >
> > Table created.
> >
> > SQL> insert into lazy values(3);
> >
> > 1 row created.
> >
> > SQL> alter table lazy modify fr number(10);
> >
> > Table altered.
> >
> > SQL> desc lazy
> > Name Null? Type
> > ----------------------------------------- -------- ------------
> >
> > FR NUMBER(10)
> >
> > Guess why I called it lazy?
> >
> > Frank
> > Francesco Marchioni wrote:
> >
> > > Hello,
> > > I have a column in my DB which is a number(2). Now my doubt is:
> > > Can I change column name & width ( to number (10) )
> > > without having to drop the column and build a new one ?
> > > In fact I'd like to save the data which is in the column.
> > > Thanks
> > > Francesco
> >
Received on Fri Oct 27 2000 - 12:54:39 CDT