>Thanks Mike.Thats a good idea.
>what i fianally did was i get all columns into a cursor and i've a routine that drops columns i dont need from the cursor.
>i mean something like
>alter table mytable drop column fld1

If it is a cursor, why not simply let the redundant field stay there, and ignore them? For a table it makes sense to remove redundant fields, but not for cursors. Or am I missing something?