How to search column name in Tables in Teradata

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;