Re: URGENT!!! How can I drop a column???

Create a new table, copy the data to the new table, dump the old table and rename the new one ?

Emilie Carton wrote:

> how can I drop a single column from a table without losing the whole my
> dates?
> I tried to do with using:
> sql> alter table "table name " drop "column name";
> but it answers me back "missing keyword"...
> How can I solve this problem?
>
> Thanks a lot
> Emilie
Received on Thu Mar 16 2000 - 00:00:00 CST