Here’s a quick tip. If you are looking to change the name on all columns in a database, for instance on primary key, you can do it by outputing the next SQL statement to text and then executing the text.

select 'sp_Rename '''+ t.name+'.'+c.name+ ''',''Guid'',''COLUMN''' 
  from sys.key_constraints as k
  join sys.tables as t
    on t.object_id = k.parent_object_id
  join sys.schemas as s
    on s.schema_id = t.schema_id
  join sys.index_columns as ic
    on ic.object_id = t.object_id
   and ic.index_id = k.unique_index_id
  join sys.columns as c
    on c.object_id = t.object_id
   and c.column_id = ic.column_id
 where k.type = 'PK';

Quick and simple!