Teradata: Is there a way to get table names & row count for a given database
(without using the stats table?),
BTW: Stats table are stale in most of the production environment !
perhaps using 2 SQLs ?, hope some Teradata expert can help
- select databasename ||.||tablename as DBTableName from dbc.TablesV WHERE tablekind=’T’
- select count(*) from DBTableName
select count(*) from DBTableName (
select databasename||.||tablename as DBTableName from dbc.TablesV WHERE tablekind=’T’
)