Could we use something like this ??

SELECT 'ALTER TABLE ' +

t.Table_Name +

' Rename column ' +

c.Column_Name +

';'

FROM Information_Schema.tables t

INNER JOIN Information_Schema.columns C

ON t.Table_name = c.Table_name

WHERE c.Column_Name LIKE '%What u want%'