Getting all table and schema names containing particular column name

Syed Sami Ur Rehman

30 Nov 2011CPOL

849

You can also use the below sp, but it's not recommented as it's not documented by Microsoft, then too it's quite handy.EXEC SP_COLUMNS NULL,NULL,NULL,'COLUMNNAME'and if you want to find it within some particular table: EXEC SP_COLUMNS...

Only logged in members can view this content

Please go to the SQL Server Table of Contents to view the list of available articles in this section.

Closed because the post is not clear, or is incomplete and has not been phrased in a way that allows it to be fully understood.. Reported by Afeefajmal on Friday, December 2, 2011 3:03pm