>Hi Cetin,
>
>Thanks for the info it worked well. I was wondering if it's possible to delete the field on the remote views programmatically?
>
>Any Idea?
>
>Thanks again...

Might be, something like:

lcSQL = dbgetprop('viewName','view','SQL')
* and get connection info
drop view ...
create sql view viewNAme remote connection connName as &lcSQL

Cetin