Preview:
SELECT tb.name [Table], c.name [Column], tp.name Type
FROM sys.tables tb
JOIN sys.columns c ON tb.object_id = c.object_id
JOIN sys.types tp ON c.system_type_id = tp.system_type_id
WHERE c.name LIKE '%ColumnName%'
ORDER BY [Table], [Column];
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter