sqlserver:
先执行以下语句:(修改表名前缀)
Select ('execute sp_rename ['+table_name+'] , ['+('xx'+substring(table_name,3,datalength(table_name)))+'];')
FROM information_schema.tables Where table_name LIKE 'xx_%';
然后将查询的结果复制再执行。
mysql:
Select CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO ', table_name,';' ) FROM information_schema.tables Where table_name LIKE 'xx_%';
如:
Select CONCAT( 'ALTER TABLE ', table_name, ' RENAME TO T_', (substring(table_name,13,length(table_name))),';' ) FROM information_schema.tables Where table_name LIKE 'xx_xx1100xx_%';