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

Thanks everybody,

I will try it !!

Dani

"AF" <af_at_nospam.com> escribió en el mensaje news:ahk97q$s48$1_at_pith.uoregon.edu...
> This should work.
> Lets say you have a table t1 with columns a, b and the offending c
>
> Create table t2 as ( Select a, b from t1)
> drop table t1
> create table t1 as (select * from t2)
> drop table t2
>
> All done. But be careful no warranty expressed or implied :)
> A
>
>
> "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 Wed Jul 24 2002 - 01:27:42 CDT