用友U8手工清除工作流资料

DECLARE @deleteBefore DATETIME;

SET @deleteBefore = '2017-1-1';

--工作流日志，这个表有可能很大，记录了工作流计算的过程，如果工作流没出错的话其实没啥用，直接清空即可
DELETE  FROM WF_CurrentLog
WHERE   CreateTime < @deleteBefore;

--流程实例锁定表
DELETE  FROM WF_PILock
WHERE   PIID IN ( SELECT    PIID
                  FROM      WF_ActiveFlow
                  WHERE     StartTime < @deleteBefore ); 

--历史状态表
DELETE  FROM WF_FlowState
WHERE   PIID IN ( SELECT    PIID
                  FROM      WF_ActiveFlow
                  WHERE     StartTime < @deleteBefore ); 

--工作流任务逻辑关系
DELETE  FROM Table_Task_Relation
WHERE   cTK_ID IN ( SELECT  cTK_ID
                    FROM    Table_Task
                    WHERE   cCreateTime < @deleteBefore ); 

--工作流任务表
DELETE  FROM Table_Task
WHERE   cCreateTime < @deleteBefore;

--流程实例表
DELETE FROM WF_ActiveFlow
WHERE   StartTime < @deleteBefore;