Ad

SQL Query For A Database Scheme

- 1 answer

In SQL Server how do you query a database to bring back all the tables that have a field of a specific name?

Ad

Answer

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
Ad
source: stackoverflow.com
Ad