Teradata has a nice command to get a quick overview on tables. This command is as follows: help statistics table_name.
In the output, I see indicators like the data and time of the creation, the number of unique rows etc.
This command can be combined with another command like: select * from dbc.tables where databasename = ‘database’ . This provides an overview on who created the table, what primary key is used.