如果包含mySQL和MsSQL中所需的字符串，则使用新名称重命名所有表名的SQL脚本。

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
AND table_name LIKE '%your_string%';

SELECT table_name
FROM information_schema.tables
WHERE table_catalog = 'your_database_name'
AND table_name LIKE '%your_string%';

SELECT CONCAT('RENAME TABLE ', table_name, ' TO ', 'new_table_name') AS rename_statement
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
AND table_name LIKE '%your_string%';

SELECT CONCAT('EXEC sp_rename ', 'your_database_name.', table_name, ', ', 'new_table_name') AS rename_statement
FROM information_schema.tables
WHERE table_catalog = 'your_database_name'
AND table_name LIKE '%your_string%';