Pasted

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