Archives of the TeradataForum
Message Posted: Tue, 07 May 2002 @ 18:25:26 GMT
| Subj: | | Re: SQL to get table name with row counts? |
| |
| From: | | John Street |
As most people have mentioned you can generate SQL statements from the DBC dictionary to get the information. For very large systems
there is the issue that the count(*)'s will take quite a long while.
If you collect statistics on the tables then a quicker method to do this would be to run help statistics dbname.tablename (again you can
generate this via SQL) it also gives you the date the stats were collected.
Another easy option if you only want a small set of tables (or in one database) is to use WinDDI where if you highlight with the cursor
the tables you want, right click and then you ca run a row count or statistics report for all the highlighted tables
Cheers
John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited
| 
