To list all the objects available in given database in Teradata

Syntax:
Option 1 :
select * from dbc.tables where databasename='<DATABASENAME>';


Option 2 : By running a normal help command on that database
help database '<DATABASENAME>';