Teradata: List tables in database

select
*
from dbc.tables
where databasename='database'
and tablekind = 'T'