Query below lists all tables Teradata databases that were created within the last 60 days

Query

select DataBaseName,
       TableName,
       CreateTimeStamp,
       LastAlterTimeStamp
from DBC.TablesV
where CreateTimeStamp > CURRENT_TIMESTAMP - INTERVAL '60' DAY
      and DatabaseName NOT IN ('All', 'Crashdumps', 'DBC', 'dbcmngr',
          'Default', 'External_AP', 'EXTUSER', 'LockLogShredder', 'PUBLIC',
          'Sys_Calendar', 'SysAdmin', 'SYSBAR', 'SYSJDBC', 'SYSLIB', 
          'SystemFe', 'SYSUDTLIB', 'SYSUIF', 'TD_SERVER_DB', 'TD_SYSFNLIB',
          'TD_SYSGPL', 'TD_SYSXML', 'TDMaps', 'TDPUSER', 'TDQCD',
          'TDStats', 'tdwm', 'SQLJ', 'SYSSPATIAL')
      and TableKind = 'T'
order by CreateTimeStamp desc,
         DatabaseName,
         TableName;

Columns

• DataBaseName - database name
• TableName - table name
• CreateTimeStamp - datetime when table was created
• LastAlterTimeStamp - datetime when table was last altered

Rows

• One row represents one table in a database
• Scope of rows: all tables databases that were created within the last 60 days
• Ordered by table creation date (descending), database name, table name

Sample results