locate for mytable where filedname or (column name)="ccc" if found() alter table mytable drop column ccc endif