Finding all tables that contain a column name

[Mike179]

Hi,

Does anyone know if it's possible to run a query to find all of the tables that contain a certain column.

For example: Search for all tables that contain the the column "CompanyID"

Thanks in advance for any help,

Mike

 

[JayKusch]

select table_name from INFORMATION_SCHEMA.columns
where column_name = 'Amount'


Thanks

J. Kusch

 

[Mike179]

Thanks Jay that's going to make my job a lot easier.

Mike