代码可以在T-sql中.
SELECT 'EXEC sp_rename ''' + TABLE_NAME + '.' + QUOTENAME(COLUMN_NAME) + ''',''' + REPLACE(COLUMN_NAME,'%','') + ''',''COLUMN''; ' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%[%]%'
这是a permalink to an actual runnable example