Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help !: How can I drop a column in a table?

Re: Help !: How can I drop a column in a table?

From: Cel <cefernan_at_capgemini.fr>
Date: Tue, 23 Jul 2002 11:29:23 +0200
Message-ID: <ahj7ma$qbo$1@s1.read.news.oleane.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US