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

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top