tags:

views:

84

answers:

3

In SqlServer. How do you query a db to bring back all the tables that have a field of a specific name?

A: 
Stu
A: 
Curt Hagenlocher
+3  A: 

The following query will bring back a unique list of Tables where Column_Name is equal to the column you are looking for:

Select
Table_Name
From
INFORMATION_SCHEMA.COLUMNS
Where
Column_Name = 'Desired_Column_Name'
Group By
Table_Name
GateKiller