TimothyK

<?xml version="1.0" encoding="utf-8" ?> 
<CodeSnippets xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet"> 
<CodeSnippet Format="1.0.0"> 
<Header>
<Title>id - Search All Tables for an Id</Title>
<Shortcut>id<!-- Not supported by MS SSMS yet --></Shortcut>
<Description>Search tables for a row</Description>
<Author>Timothy Klenke</Author> 
<SnippetTypes><SnippetType>Expansion</SnippetType></SnippetTypes>
</Header>

TimothyK

/* Script: Column Search with Descriptions
** Author: Timothy Klenke
** Date: 2014-02-27
** License: Public domain, unlicenced
**/
 
Select 
--** Schema Name
	--sch.name As 'Schema',
--** TableName

TimothyK

/* Script: Column Search
** Author: Timothy Klenke
** Date: 2014-02-16
** License: Public domain, unlicenced
**/

Select 
	--sch.name As 'Schema',
	obj.name As 'Table',
	col.name As 'Column'