Steven,

From the amount of I/O that an alter table command would do, you may as well just:

select ... ;  && everything but the column you want to drop
   from ... ;
   into cursor ... ;

> Learnt from error message that command Alter Table mycursorname Drop a_column_name is invaild to a cursor,but i sometimes do need so to do.