若依集成flowable删除表操作

原创已于 2025-09-15 14:51:46 修改 · 137 阅读

CC 4.0 BY-SA版权

文章标签：

于 2025-09-11 17:22:12 首次发布

查询act表中的外键并生成删除外键语句
SELECT
	TABLE_NAME,
	CONCAT( 'DELETE   from ', TABLE_NAME, ';' ) '清空数据',
CONCAT( ' DROP TABLE ', TABLE_NAME, ';' ) '删除表',
CONCAT( '	RENAME TABLE ', TABLE_NAME, ' TO ', UPPER( TABLE_NAME ), ';' ) '修改标明为大写',
t.* 
FROM
	INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS t 
WHERE
	( table_name LIKE 'act_%' OR table_name LIKE 'ACT_%' ) 
	AND CONSTRAINT_schema = 'gadg_scm_dev';

查询flw表中的外键并生成删除外键语句
SELECT
	TABLE_NAME,
	CONCAT( 'DELETE   from ', TABLE_NAME, ';' ) '清空数据',
CONCAT( ' DROP TABLE ', TABLE_NAME, ';' ) '删除表',
CONCAT( '	RENAME TABLE ', TABLE_NAME, ' TO ', UPPER( TABLE_NAME ), ';' ) '修改标明为大写',
t.* 
FROM
	INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS t 
WHERE
	( table_name LIKE 'act_%' OR table_name LIKE 'ACT_%' ) 
	AND CONSTRAINT_schema = 'gadg_scm_dev';



查询act表并生成删除表语句
 
SELECT
	TABLE_NAME,
	CONCAT( 'DELETE   from ', TABLE_NAME, ';' ) '清空数据',
CONCAT( ' DROP TABLE ', TABLE_NAME, ';' ) '删除表',
CONCAT( '	RENAME TABLE ', TABLE_NAME, ' TO ', UPPER( TABLE_NAME ), ';' ) '修改标明为大写' 
FROM
	INFORMATION_SCHEMA.TABLES 
WHERE
	TABLE_SCHEMA = 'gadg_scm_dev' 
	AND ( TABLE_NAME LIKE 'ACT_%' OR TABLE_NAME LIKE 'act_%' );

查询flw表并生成删除表语句
SELECT
	TABLE_NAME,
	CONCAT( 'DELETE   from ', TABLE_NAME, ';' ) '清空数据',
CONCAT( ' DROP TABLE ', TABLE_NAME, ';' ) '删除表',
CONCAT( '	RENAME TABLE ', TABLE_NAME, ' TO ', UPPER( TABLE_NAME ), ';' ) '修改标明为大写' 
FROM
	INFORMATION_SCHEMA.TABLES 
WHERE
	TABLE_SCHEMA = 'gadg_scm_dev' 
	AND ( TABLE_NAME LIKE 'FLW_%' OR TABLE_NAME LIKE 'flw_%' );