Find column in MSSql
SELECT col.name AS 'ColumnName', tab.name AS 'TableName' FROM sys.columns col JOIN sys.tables tab ON col.object_id = tab.object_id WHERE col.name like '%column_name_to_find%' ORDER BY TableName,ColumnName; Credit: https://intellipaat.com/community/6615/find-all-tables-containing-column-with-specified-name-ms-sql-server