List tables in Teradata database

Query below lists all tables in 'DBC' Teradata database.

Query

SELECT  DatabaseName,
        TableName,
        CreateTimeStamp,
        LastAlterTimeStamp
FROM    DBC.TablesV
WHERE   TableKind = 'T'
and     DatabaseName = 'DBC'
ORDER BY    TableName;

Columns

  • DatabaseName - database name
  • TableName - table name
  • CreateTimeStamp - date & time when table was created
  • LastAlterTimeStamp - date & time when table was last modified by using an ALTER statement

Rows

  • One row represents one data table in the database
  • Scope of rows: all tables in provided database
  • Ordered by table name

Sample results

You could also get this

Get this interactive HTML data dictionary in minutes with Dataedo.

See live HTML data dictionary sample

Try for free

0
There are no comments. Click here to write the first comment.