Contents
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%']