Find a table by the name in Teradata database

Query below finds tables with specific name in all databases of Teradata Database. In this case it searches for 'Countries' table.


SELECT  DatabaseName,
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.

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.