怎样安全地删除与工作流有关的角色与操作

robin

其sql语句示例如下：
删除角色
deletefrom maxrole t where t.maxrole in(select t1.roleid from wfassignment t1 where t1.assigncode is null and t1.wfid=0 and t1.processname='JXCK'and t1.processrev=1)
and not exists(select 1 from wfassignment t2 where t2.assigncode is null and t2.wfid=0 and t2.processname<>&#39;JXCK&#39; and t2.roleid=t.maxrole) ;

删除操作
deletefrom action where action in (select t.action from wfaction t where t.processname=&#39;JXCK&#39; and t.processrev=1) AND
NOT exists(select 1 from wfaction t1 where t1.processname<>&#39;JXCK&#39; and t1.action=action.action)