flowable6.3教程-清空表中的数据

-- 删除所有run开头的表
delete from act_ru_timer_job  where 1=1;
delete from  act_ru_job  where 1=1;
delete from  act_ru_identitylink  where 1=1;
delete from  act_ru_deadletter_job  where 1=1;
delete from  act_ru_event_subscr  where 1=1;
delete from  act_ru_suspended_job  where 1=1;
delete from  act_ru_history_job  where 1=1;
delete from  act_ru_variable  where 1=1;
delete from   act_ru_task where 1=1;
delete from  act_ru_execution where 1=1;
-- 删除所有his开头的表
delete from  act_hi_actinst where 1=1;
delete from  act_hi_attachment where 1=1;
delete from  act_hi_comment where 1=1;
delete from  act_hi_detail where 1=1;
delete from  act_hi_identitylink where 1=1;
delete from  act_hi_procinst where 1=1;
delete from  act_hi_taskinst where 1=1;
delete from  act_hi_varinst where 1=1;
-- 删除所有ge开头的表 (应该是设计流程图对应的内容)
delete from  act_ge_bytearray where 1=1;
delete from  act_ge_property where 1=1;
-- 删除所有re开头的表(实际部署的)
delete from  act_re_deployment where 1=1;
delete from  act_re_model where 1=1;
delete from  act_re_procdef where 1=1;

原文出处:/show_1IX5cAFz5QbI.html