How to retrieve the names of all tables in the Teradata database?

To search for all table names in the Teradata database, you can use the following SQL statement:

SELECT TableName
FROM DBC.TablesV
WHERE TableKind = 'T'
  AND DatabaseName = 'your_database_name';

In the above statement, replace “your_database_name” with the name of the database you want to query. Executing this query will return the names of all tables in that database.