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

Try

ALTER TABLE <schema_name:optional>.<table_name> DROP COLUMN <column_name> or
ALTER TABLE <schema_name:optional>.<table_name> DROP ( <column_name1>, ..., <column_namex>)

Regards,

Patrick

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