Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT t.name AS table_name,
- SCHEMA_NAME(schema_id) AS schema_name,
- c.name AS column_name
- FROM sys.tables AS t
- INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
- WHERE c.name LIKE '%NRI%'
- ORDER BY schema_name, table_name;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement