<?xml version="1.0" encoding="utf-8"?>
			<Title>Search column</Title>
					<ToolTip>Name of the column</ToolTip>
			<Code Language="SQL">
<![CDATA[SELECT [Schema], [Table], [Column], [Type]
FROM sys.schemas s
JOIN sys.tables tb ON tb.schema_id = s.schema_id
JOIN sys.columns c ON c.object_id = tb.object_id
JOIN sys.types tp ON tp.system_type_id = c.system_type_id
WHERE LIKE N'$ColumnName$'
AND NOT = N'sysname'
ORDER BY [Schema], [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