There is a drop column option for the alter table command in 8.1.6. I don't
think you can rename columns, just drop and recreate them.
--
Richard Armstrong
Sunny <sunnyb_at_vendtek.bc.ca> wrote in message
news:8i3oaq$ruk$1_at_newsfeed.smartt.com...
> Hey bob if you find it out let me too, i am also wondering if you can or
> cant
> change the columns name
> thanks
>
> Bob Fazio <rfazio_at_home.com.nospam> wrote in message
> news:6vG%4.239772$Tn4.2174073_at_news1.rdc2.pa.home.com...
> > With 8.0 you can't rename a column at all. With 8.1 (8i) I believe so,
> > haven't tried.
> >
> > --
> > Robert Fazio, Oracle DBA
> > rfazio_at_home.com
> > remove nospam from reply address
> > http://24.8.218.197/
> > "Nasir" <nmajeed_at_prosweb.com> wrote in message
> >
news:B993834534D63B21.954B8F509C198AC5.B50C18AB58EFD953_at_lp.airnews.net...
> > > Hi,
> > >
> > > Is it possible to rename a column when the table has data in it ?
> > >
> > > Thanks,
> > > Nasir
> > > nmajeed_at_prosrm.com
> > >
> > >
> > >
> >
> >
>
>
Received on Tue Jun 13 2000 - 00:00:00 CDT
