SQL元数据列头英文转中文

粘贴以下代码，替换对应的表名和元数据，并执行SQL语句

update sys_appfields s set s.fieldname = (select replace(replace(comments,'[',''),']','') from user_col_comments where table_name like 'IC_%' and column_name = s.fieldcode and table_name in (select maintable from sys_app t where t.appid = s.appid)) where s.appid like 'IC_%';