SELECT t.DatabaseName, t.TableName, c.columnname FROM DBC.TablesV t INNER JOIN DBC.ColumnsV c ON t.DatabaseName = c.DatabaseName AND t.TableName = C.TableName WHERE UPPER(c.ColumnName) like '%ColumnName%' -- Make the column name in Upper case letter, so in case its in lower case letter in database the record shows AND t.TableKind = 'T' ORDER BY t.DatabaseName, t.TableName; |