Get all databases in the Teradata system

SELECT * FROM DBC.Databases

Get all tables in a particular database

SELECT * FROM DBC.Tables WHERE DatabaseName='DbName'

List all fields in a table

HELP TABLE TableName

OR

SELECT * FROM DBC.Columns [WHERE TableName Like '%TblName%'] [AND ColumnName Like '%ColName%']