In SqlServer. How do you query a db to bring back all the tables that have a field of a specific name?
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