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%'