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;

Comments