Advertisement
private775

SQL Server: All columns with specific name

Sep 14th, 2017
325
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.31 KB | None | 0 0
  1. SELECT
  2. o.type_desc,
  3.   s.name + '.' + o.name [Object Name],
  4.   c.[name] [COLUMN Name]
  5. FROM [K2].[sys].[all_columns] c
  6.   INNER JOIN [sys].[all_objects] o ON c.object_id = o.object_id
  7.   INNER JOIN [sys].[schemas] s ON o.schema_id = s.schema_id
  8.   WHERE c.[name] LIKE '%originator%'
  9.   AND o.TYPE = 'U'
  10.   ORDER BY 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement