流程管理语句

一、查询流程


SELECT * FROM ACT_GE_BYTEARRAY;
SELECT * FROM ACT_GE_PROPERTY;
SELECT * FROM ACT_HI_ACTINST;
SELECT * FROM ACT_HI_ATTACHMENT;
SELECT * FROM ACT_HI_COMMENT;
SELECT * FROM ACT_HI_DETAIL;
SELECT * FROM ACT_HI_IDENTITYLINK;
SELECT * FROM ACT_HI_PROCINST;
SELECT * FROM ACT_HI_TASKINST;
SELECT * FROM ACT_HI_VARINST;
SELECT * FROM ACT_ID_GROUP;
SELECT * FROM ACT_ID_INFO;
SELECT * FROM ACT_ID_MEMBERSHIP;
SELECT * FROM ACT_ID_USER;
SELECT * FROM ACT_RE_DEPLOYMENT;
SELECT * FROM ACT_RE_MODEL;
SELECT * FROM ACT_RE_PROCDEF;
SELECT * FROM ACT_RU_EVENT_SUBSCR;
SELECT * FROM ACT_RU_EXECUTION;
SELECT * FROM ACT_RU_IDENTITYLINK;
SELECT * FROM ACT_RU_JOB;
SELECT * FROM ACT_RU_TASK;
SELECT * FROM ACT_RU_VARIABLE;

------------------------------------------------------------------------------

二、删除流程


--DELETE FROM ACT_GE_PROPERTY; --该表为流程属性表表，不能删除（清空后，代码会报错）
--DELETE FROM ACT_GE_BYTEARRAY; --该表为流程定义表，不能删除（如果需要重新定义所有流程可以删除）
--DELETE FROM ACT_RE_PROCDEF; --该表为已部署的流程定义表，不能删除（如果需要重新定义所有流程可以删除）
--DELETE FROM ACT_RE_DEPLOYMENT; --该表为流程部署信息表，不能删除（如果需要重新定义所有流程可以删除）
DELETE FROM ACT_HI_ACTINST;
DELETE FROM ACT_HI_ATTACHMENT;
DELETE FROM ACT_HI_COMMENT;
DELETE FROM ACT_HI_DETAIL;
DELETE FROM ACT_HI_IDENTITYLINK;
DELETE FROM ACT_HI_PROCINST;
DELETE FROM ACT_HI_TASKINST;
DELETE FROM ACT_HI_VARINST;
DELETE FROM ACT_ID_GROUP;
DELETE FROM ACT_ID_INFO;
DELETE FROM ACT_ID_MEMBERSHIP;
DELETE FROM ACT_ID_USER;
DELETE FROM ACT_RE_MODEL;
DELETE FROM ACT_RU_IDENTITYLINK;
DELETE FROM ACT_RU_JOB;
DELETE FROM ACT_RU_TASK;
DELETE FROM ACT_RU_VARIABLE;
DELETE FROM ACT_RU_EVENT_SUBSCR;
DELETE FROM ACT_RU_EXECUTION;