<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets>
	<CodeSnippet>
		<Header>
			<Title>Search column</Title>
		</Header>
		<Snippet>
			<Declarations>
				<Literal>
					<ID>ColumnName</ID>
					<ToolTip>Name of the column</ToolTip>
					<Default>ColumnName</Default>
				</Literal>
			</Declarations>
			<Code Language="SQL">
<![CDATA[SELECT s.name [Schema], tb.name [Table], c.name [Column], tp.name [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 c.name LIKE N'$ColumnName$'
AND NOT tp.name = N'sysname'
ORDER BY [Schema], [Table], [Column];]]>
			</Code>
		</Snippet>
	</CodeSnippet>
</CodeSnippets>