List all the tables and row counts in Teradata SQL?

Question

I would like to translate the following Oracle SQL query into Teradata SQL:

SELECT table_name, num_rows FROM ALL_TABLES

This query retrieves all the tables along with the number of rows. What is the Teradata SQL equivalent?

Answer 1

Try this and play :)

SELECT DatabaseName, TableName, CreateTimeStamp, LastAlterTimeStamp FROM DBC.TablesV