SELECT 
o.type_desc,
  s.name + '.' + o.name [Object Name], 
  c.[name] [Column Name]
FROM [K2].[sys].[all_columns] c
  inner join [sys].[all_objects] o on c.object_id = o.object_id 
  inner join [sys].[schemas] s on o.schema_id = s.schema_id
  where c.[name] like '%originator%'
  and o.type = 'U'
  order by 2