List of tables and columns in Teradata database

How to extract list of columns, Tables in database (using Teradata SQL)
Syntax:

SELECT DatabaseName, TableName, ColumnName, ColumnFormat, ColumnType, ColumnLength, Nullable             

,(CASE

WHEN columntype='CV' THEN 'VARCHAR'

WHEN columntype='DA' THEN 'DATE'

WHEN columntype='I' THEN 'INTEGER'

WHEN columntype='CF' THEN 'CHAR'

WHEN columntype='F' THEN 'FLOAT'

WHEN columntype='I1' THEN 'BYTEINT'

WHEN columntype='I2' THEN 'SMALLINT'

WHEN columntype='I8' THEN 'BIGINT'

WHEN columntype='BO' THEN 'BLOB'

WHEN columntype='CO' THEN 'CLOB'

WHEN columntype='TS' THEN 'TIMESTAMP'

WHEN columntype='BF' THEN 'BYTE'

WHEN columntype='SZ' THEN 'TIMESTAMP W/ZONE'

WHEN columntype='BV' THEN 'VARBYTE'

WHEN columntype='DM' THEN 'INVERVAL DAY TO MINUTE'

WHEN columntype='D' THEN 'DECIMAL'

ELSE columntype END) 

AS DataType

FROM DBC.COLUMNS

WHERE databasename = 'DatabaseName'