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