brgdotnet
asked on
New a query that will search database for all tables that have a certain column name in common.
I need a query that will search all of the tables in my database that have a common column name. For example if I have a column named ClientId, I need to find all data tables in the database that have a column named "ClientId". Does anyone know of a query that would do that?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Jim Horn - Short and concise... I like your solution as well.
Regards
Regards
ASKER