Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement