Query below finds tables with specific name in all databases of Teradata Database. In this case it searches for 'Countries' table.
SELECT DatabaseName, TableName FROM DBC.TablesV WHERE TableKind = 'T' AND TableName = 'Countries' ORDER BY DatabaseName;
- DatabaseName - name of database where table was found in
- TableName - name of table (redundant as it should be exactly the same as provided)
- One row represents one table
- Scope of rows: all found tables
- Ordered by database name
There might be more tables than one because different databases can have tables with the same names.