Re: how can I drop a column from a table??? Hurry up, please

Jorge schrieb:

> Hi, and please tell me, how can I drop a column from a table???

  Hi Jorge,

1. Create a new table for the data of the old table: create table new as select * from old; Then drop the old table and recreate it: create table old as select col1, col2, ... from new (omit the column yout want to delete);
2. If you can't drop the table, issue an 'update old set column = null'.

    Than create a view and omit the column.

As you see, there is no way to delete a column easily.

HTH, buenos tardes
Guido Received on Tue Sep 15 1998 - 00:00:00 CEST