æ¥ç³»ç»è¡¨ãæ°æ®åå
¸ä¹ç±»çæ¼sqlæ¥æ§è¡å
oracleï¼
1
2
3
select 'alter table '||c.table_name||' rename column '||c.column_name||' to D;'
from user_tab_columns c
where c.column_name in ('A','B','C')
sqlserverï¼
1
2
3
select 'execute sp_rename "'+t.name+'.'+c.name+'", D' from sys.tables t
inner join sys.columns c on t.object_id=c.object_id
where c.name in ('A','B','C')
å
¶ä»æ°æ®åºçè¯ï¼èªå·±æ¹æ¹è¯å¥å
温馨提示:答案为网友推荐,仅供参考