SQL Server Scripts : List all tables name that contain particularcolumn name using SQL Query

[Jayesh Sorathia]

There are many situations where you want to get all tables name that contains particular column name using sql query.

Click here to view query. Click here... http://jayeshsorathia.blogspot.com/...name-that-contain-particular-column-name.html

This is the very useful SQL Server Scripts.

 

[Arne Vajhøj]

On 8/31/2012 3:35 AM, Jayesh Sorathia wrote:> There are many situations
where you want to get all tables name that contains particular column
name using sql query.

This is the very useful SQL Server Scripts.

Somewhat.

But using the sys tables is not the best way to get that
information.

Selecting from INFORMATION_SCHEMA.COLUMNS is both easier to
read and more portable.

Arne