출처 : <a href="http://blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/" target="_blank">http://blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/</a> 
 
 
<a href="http://www.motolies.tistory.com/248" target="_blank">2013/02/15 - [프로그램 자료/MS-SQL] - DB에서 모든 프로시져, 뷰, 테이블, 스칼라 함수 내 쿼리 검색 Procedure 검색 프로시저, 뷰, 테이블, 스칼라 함수 쿼리 내 문구 찾기 Searching Query in Procedure</a> 
USE 디비명
GO
SELECT t.name AS table_name,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SCHEMA_NAME(schema_id) AS schema_name,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c.name AS column_name
FROM sys.tables AS t
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%검색어%'
ORDER BY schema_name, table_name;
&nbsp;

모든 테이블에서 속성 칼럼 Column 열 이름 검색