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

From: AF <af_at_nospam.com>
Date: Tue, 23 Jul 2002 11:59:00 -0700
Message-ID: <ahk97q$s48$1@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 Tue Jul 23 2002 - 13:59:00 CDT