泛微数据库更改流程字段类型

select * into formtable_main_37_back from formtable_main_37;

alter table formtable_main_37 alter column bjdice varchar(200);–需修改字段替换成自己所要改的    

SELECT * FROM workflow_billfield WHERE id =35905 OR id =35906 OR id =35907 OR id =35908

update workflow_billfield set fielddbtype='varchar(100)',qfws=0,type=1 where id=9964–id值就是自己刚才修改的字段id