1.获取所有相同前缀的表,例如"ACT_",其中"myDemo"是数据库:
SELECT CONCAT( 'drop table if exists ', table_name , ';')
AS statement FROM information_schema.tables
WHERE table_schema = 'myDemo' AND table_name LIKE 'ACT_%';
2.复制所有查询结果,并在删除表语句前后关闭和恢复外键约束检查开关:
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE ACT_DE_DATABASECHANGELOG;
DROP TABLE ACT_DE_DATABASECHANGELOGLOCK;
DROP TABLE ACT_DE_MODEL;
DROP TABLE ACT_DE_MODEL_HISTORY;
DROP TABLE ACT_DE_MODEL_RELATION;
DROP TABLE ACT_HI_ENTITYLINK;
DROP TABLE ACT_HI_IDENTITYLINK;
DROP TABLE ACT_HI_TASKINST;
DROP TABLE ACT_HI_TSK_LOG;
DROP TABLE ACT_HI_VARINST;
DROP TABLE ACT_ID_BYTEARRAY;
DROP TABLE ACT_ID_GROUP;
DROP TABLE ACT_ID_INFO;
SET FOREIGN_KEY_CHECKS=1;
这样即可一键删除所有表了。