Teradata - All tables and column names list

This works both on tables and on views:

select

      *

from

      DBC.columns

where

      DatabaseName = 'DATABASE_NAME_HERE'

      and TableName like '%TABLE_NAME_HERE%'

      and ColumnName like '%COLUMN_NAME_HERE%'

;

HELP COLUMN DATABASE_NAME_HERE.TABLE_NAME_HERE.*;