DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Find A Column By Name On MS SQL Server
// If you need to find the location and owning table of a column on a large database, this is a very simple and quick search query. // By default it's looking only at user tables (type 'U').
SELECT o.name,c.name FROM sysobjects o inner join syscolumns c on o.id = c.id WHERE o.type = 'U' and c.name LIKE '%whatever%'