Hey everyone! Welcome back to SQL Something!
Really quick post today. Today we look at finding a table(s) that a column belongs to. Had to find a solution to do this recently and thought it would helpful to share.
The answers we seek can be found in the following SQL Server system views:
We will retrieve the related column names from sys.columns and the table names from sys.tables.
Putting it together we get the following:
SELECT c.name AS ColumnName, t.name AS TableName
FROM sys.columns c
JOIN sys.tables t
ON c.object_id = t.object_id
WHERE c.name LIKE '%YourColumn%'
ORDER BY ColumnName, TableName;
The above will list all tables that have a column name like the given column name ('YourColumn').
And there we go. :-)
DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to
politely correct or comment as you see fit. Your feedback is always
welcomed. :-)
Original Reference: https://stackoverflow.com/questions/26293085/find-all-table-names-with-column-name
