To get all the tables in Teradata

To get all table names in teradata

SELECT * FROM dbc.tables WHERE tablekind = 'T'


If you want to get, all the tables present in sales database

SELECT * FROM dbc.tables WHERE tablekind = 'T' and databasename='SALES'