Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help !: How can I drop a column in a table?
you need to make a copy of the table you want to modify and
drop the old one ...
"dani" <drezusta_at_airtel.net> a écrit dans le message news:
ahj5tk$p41$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> "ORA-00905: missing keyword"
> I don't know what is the correct keyword
>
> thanks
>
> dani
>
>
> "Steve Rainbird" <steve.rainbird_at_nospam.mssint.com> escribió en el mensaje
> news:ahj4h3$116$1_at_venus.btinternet.com...
> > What error message do you get?
> >
> > --
> > Steve Rainbird
> > Principal consultant
> > MSS International Ltd.
> > www.mssint.com
> >
> > Remove "nospam" from email address to reply
> >
> > "dani" <drezusta_at_airtel.net> wrote in message
> > news:ahj2k7$9ad$1_at_nsnmrro2-gest.nuria.telefonica-data.net...
> > > Hi,
> > > I got a problem, I don't know what it's the correct syntax to
eliminate
> a
> > > column in a table.
> > > I've tried with : "ALTER TABLE t DROP COLUMN c", but doesn't work
> > >
> > > Any idea ?
> > >
> > > thanks
> > >
> > >
> > > Dani
> > >
> > >
> >
> >
>
>
Received on Tue Jul 23 2002 - 04:29:23 CDT
![]() |
![]() |